martes, 27 de octubre de 2009

CREAR UNA COPIA EXACTA DE OTRA HOJA

Algunas veces deseamos copiar una información o formato de una hoja de EXCEL a otra, esperando que esta al copiarse a la otra sea EXACTAMENTE igual. Esta sería una opción:


Paso 1. Posiciónese en la hoja de Excel que desea copiar. FACTURA 1 le llamaremos en este ejemplo.


Paso 2. Haga clic derecho sobre la pestaña donde se ubica el nombre de la hoja. En este caso haga clic derecho sobre el nombre FACTURA 1. Al instante, se desplegara el menú contextual, del cual deberá elegir la opción Mover o Copiar (move or copy de acuerdo a el ejemplo de esta imagen).

Paso 3. Una vez elegida la opción Mover o Copiar, una nueva ventana aparecerá. En ella saldrá el total de las hojas que contiene su libro.

Deberá seleccionar en que posición de la lista desea que aparezca su copia, es decir, ¿Desea que aparezca al lado izquierdo o derecho de la hoja original? O ¿Desea que la hoja se desplace al final o se ubique algunas hojas más adelante o más atrás?

Siguiendo con el proceso, seleccione la hoja según su conveniencia y active la casilla Crear una copia (create a copy de acuerdo a la imagen).

Paso 4. Una vez creada la copia, solo deberemos cambiar el nombre (Haciendo clic derecho> renombrar) o bien hasta volver reubicarla si consideramos necesario (Dando clic sostenido en el ratón sobre la hoja y moviéndola izquierda o derecha).


Paso 5. Listo, la hoja se ha creado como una replica exacta de la Hoja Original FACTURA 1 y ahorta tiene tiene un clon llamado FACTURA 2.

Notas:

  • Para agregar color a la pestaña solo: De clic derecho en el ratón > paleta de colores > seleccione el color deseado.
  • Para copiar distintas hojas simultáneamente: Presione CTRL fijamente mientras al mismo tiempo va seleccionando con el cursor del ratón las hojas que necesita crear una replica > Siga posteriormente los 5 pasos de este tutorial.


Publicado por: Julio Rosales V.



49 comentarios:

  1. I don't even know the way I finished up right here, however I believed this publish was good. I don't understand who you might be but definitely you are going
    to a famous blogger in the event you are not already. Cheers!


    Stop by my site ... Buy zinncollection

    ResponderEliminar
  2. bookmarked!!, I like your blog!

    Check out my site - Buy Test Force

    ResponderEliminar
  3. This website definitely has all of the information I wanted about this subject and
    didn't know who to ask.

    Here is my website: Anatomy X5

    ResponderEliminar
  4. Greetings! This is my first visit to your blog! We are a collection of volunteers and starting a new initiative in a community in the same niche.

    Your blog provided us valuable information to work on. You have
    done a wonderful job!

    my web page Lean muscle x review

    ResponderEliminar
  5. You're so cool! I don't suppose I've read through a single thing like this before. So great to discover somebody with original thoughts on this issue. Seriously.. many thanks for starting this up. This web site is something that is needed on the internet, someone with a little originality!

    Here is my blog post - Pure GCE

    ResponderEliminar
  6. Aw, this was an incredibly good post. Spending some time
    and actual effort to produce a superb article… but what can I say… I procrastinate a whole lot and never manage to get nearly anything done.


    My web-site :: Best Male Enhancement

    ResponderEliminar
  7. Excellent pieces. Keep posting such kind of info on your page.

    Im really impressed by your blog.
    Hi there, You've done a fantastic job. I'll
    definitely digg it and in my opinion suggest to my friends.

    I am sure they will be benefited from this website.


    Visit my page; greentoneproblog.com

    ResponderEliminar
  8. After looking over a few of the articles on your website,
    I seriously like your way of writing a blog.
    I book marked it to my bookmark site list and will be checking back soon.
    Take a look at my website too and let me know your opinion.


    Here is my site - Ripped Muscle Xtreme

    ResponderEliminar
  9. I'm extremely impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Anyway keep up the nice quality writing, it is rare to see a nice blog like this one these days.

    Here is my web page: timex marathon

    ResponderEliminar
  10. Muchas gracias, es JUSTO lo que estaba buscando aun en el 2018 esta publicación es muy útil.

    ResponderEliminar
  11. I was looking for this kind of valuable information. Your article is really helpful for me. Thanks a lot.

    Disqus

    Live Journal

    Metal Archives

    Magcloud

    My Space

    OpenStreetMap

    Viki

    WorldCosplay

    Aunbox

    DeviantArt

    ResponderEliminar
  12. I was looking for this kind of valuable information. Your article is really helpful for me. Thanks a lot.

    Metal Archives

    Viki

    SoundCloud

    GetSatisfication

    Vimeo

    8tracks

    Feedbooks

    Photoshop Creative

    Udemy

    ColourLovers

    ResponderEliminar
  13. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    Good Tutorials

    Toprecepty

    Gameatopia

    Gtainside

    Windy

    Quup

    Davehakkens

    Disquaire

    Enetget

    Transition

    ResponderEliminar
  14. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    Disqus

    Openstreetmap

    Metal Archives

    Magcloud

    Brooklynne

    Redbubble

    Viki

    WorldCosplay

    Listly

    DeviantArt

    ResponderEliminar
  15. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    Spreaker

    MobyPicture

    Weheartit

    Github

    Thepetitionsite

    Toyota4runner

    Powwows

    Gust

    Stylemepretty

    Gifyu

    ResponderEliminar
  16. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    Deamdth

    DigitalOcean

    Spry

    Bandcamp

    Ibosocial

    Morguefile

    YouPic

    Vimity

    FunnyorDie

    Loopdesk

    ResponderEliminar
  17. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    TheDailyRadish

    TechnoZooo

    TechStrange

    LifeStyleByPs

    GetinFoon

    EasyLifeJourney

    MyInfoExpert

    ResponderEliminar
  18. I was looking for this kind of valuable information.
    Your article is really helpful for me. Thanks a lot.


    Site123

    Mex

    ConstantContact

    Bloglovin

    EmySpot

    SimpleSite

    Voog

    Doodlekit

    Imfaceplate

    Cabanova

    ResponderEliminar
  19. Wow really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    Bricksite

    MeeNu

    Blogocial

    Diowebhost

    Xtgem

    Kiwibox

    Shutterfly

    Deviantart

    Site123

    Ralphtolbert

    ResponderEliminar
  20. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    Technozooo

    ResponderEliminar
  21. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    Live Journal

    ResponderEliminar
  22. Awesome article, I appreciate your efforts.

    MobyPicture

    ResponderEliminar
  23. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    Wanelo

    ResponderEliminar
  24. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    MEE

    ResponderEliminar
  25. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    MIXCLOUD

    ResponderEliminar
  26. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    FOLLOWUS

    ResponderEliminar
  27. Awesome article, I appreciate your efforts.

    GIANTBOMB

    ResponderEliminar
  28. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    LIVEJOURNAL

    ResponderEliminar
  29. Wow, really impressive guide about the topic that I was looking for. Thank you so much for this awesome guide.

    METAL ARCHIVES

    ResponderEliminar
  30. Give your furry friend the gift of comfort with this super soft Calminnng Pet Bed "Express Yudu" for dogs and cats.
    Our beds feature a round design, creating a cozy and protective atmosphere.
    Pets will feel surrounded by love and warmth, allowing them to experience truly restful sleep.
    The bolstered edge also acts as a headrest, offering additional orthopedic support.

    ResponderEliminar
  31. Give your furry friend the gift of comfort with this super soft Calminnng Pet Bed "Gitlab" for dogs and cats.
    Our beds feature a round design, creating a cozy and protective atmosphere.
    Pets will feel surrounded by love and warmth, allowing them to experience truly restful sleep.
    The bolstered edge also acts as a headrest, offering additional orthopedic support.

    ResponderEliminar
  32. Give your furry friend the gift of comfort with this super soft Vingtage Motorcycle Helmet "MobyPicutre" for dogs and cats.
    Our beds feature a round design, creating a cozy and protective atmosphere.
    Pets will feel surrounded by love and warmth, allowing them to experience truly restful sleep.
    The bolstered edge also acts as a headrest, offering additional orthopedic support.

    ResponderEliminar
  33. Buy roids mania Anabolic Steroids Online from USA online pharmacy, Buy steroids.
    Buy HGH, Buy Peptides. We Offer best injectable steroids, Winstrol tabs price.
    And storage of fat and increases propionate was first published in the year.
    danabol
    https://roidsmania.com/

    ResponderEliminar
  34. This error message shows up when your account is locked after too many login attempts failures. In this case, you can unlock your account by resetting the password. Again, we recommend trying resetting your password a few minutes later. Also, please take into account that it may take a few more minutes for you to log in successfully after resetting the password.

    PUBG

    ResponderEliminar
  35. Bệnh sùi mào gà ở dương vật thường do nam giới có quan hệ tình dục không an toàn gây ra. Đôi khi, nam giới có thói quen dùng chung đồ lót, khăn tắm,… với người mang virus HPV gây ra.

    ResponderEliminar
  36. WinZip Pro 26.0 Crack could be your extremely ideal PC compacting instrument that is utilized to restore the norm of information.

    ResponderEliminar
  37. replica evening bags replica hermes bags t6x02t3k94 replica chanel bags ebay replica bags philippines gucci replica n7v65o8s78 replica bags thailand site l3y98p4e40 designer replica luggage replica evening bags

    ResponderEliminar

Son bienvenidos todos tus comentarios dudas o cualquier idea que quieras compartir.

Mandanos un mail: