imprimir hoja excel sin cortes

Cómo imprimir en Excel sin cortes

Cómo imprimir en Excel

Seguro que te ha pasado que has querido imprimir Excel en una hoja y ha salido el documento cortado. Sigue leyendo y descubre de forma muy sencilla cómo imprimir una hoja de Excel completa.

Lo primero que debemos tener en cuenta, tanto en Excel como en otros programas de hojas de cálculo, es que debemos ajustar la página. Dado que Excel es el programa de este tipo más utilizado, hablaremos sobre cómo configurar una hoja de Excel para imprimir.

Imprimir documento Excel en una hoja

Las hojas de Excel son infinitas y podemos crear tablas inmensas que al visualizar en «Vista Previa» se corta y por tanto si la imprimimos no saldrá una hoja completa.

Primero debemos comprobar si tal y como está el documento, en Vista Previa aparece todo el contenido del documento o si hay partes que no. Para ello vamos a Archivo > Imprimir y se abrirá la ventana de Vista Previa. Aquí podemos comprobar como quedará el documento impreso.

vista previa imprimir

Área de impresión Excel

Si no aparece la tabla completa sigue estos pasos para saber cómo seleccionar área de impresión en Excel.

Establecer área de impresión Excel

    1. Seleccionamos todo el contenido que deseamos imprimir. Podemos arrastrar con el ratón o haciendo clic en la primera celda y manteniendo presionada la tecla Shift (Mayúsculas), seleccionamos la última celda.
    2. Una vez tengamos seleccionado el documento, hacemos click en Diseño de página > Área de Impresión> Establecer área de impresión. Aparecerá una línea gruesa que rodea la zona y dentro de este área otra línea de puntos más delgada que nos indicará la parte del documento que queda fuera del área de impresión de la hoja.área de impresión

 

  1. Necesitaremos realizar algunos cambios para ajustar el formato como pueden ser reducir el ancho de las columnas o la fuente hasta que desaparezca la línea. También podemos modificar la orientación de la hoja haciendo clic en Diseño de página > Orientación.

orientación página

 

Configurar impresión en Vista Previa

Para poder comprobar si los ajustes que hemos realizado para ajustar tabla Excel para imprimir debemos comprobar de nuevo cómo aparece en Vista Previa.

Es aconsejable activar la opción de mostrar las líneas de división del área de impresión y así verificar el resultado de la impresión. Para ello debemos hacer clic en Configurar Página dentro de la ventana de Vista Previa. Vamos a la pestaña Hoja > marcar en Imprimir «Líneas de impresión».

lineas de divisón en vista previa

Por último, seleccionamos Escalado y hacemos clic en Ajustar hoja en una página.

opciones de escalado de página

Con estos sencillos pasos, podrás imprimir hoja Excel sin cortes.

308 comentarios sobre «Cómo imprimir en Excel sin cortes»

  1. Pingback: keto advanced
  2. Pingback: help write essay
  3. Pingback: paid essay writing
  4. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.
    You obviously know what youre talking about, why waste your intelligence
    on just posting videos to your blog when you could be giving
    us something enlightening to read?

  5. Hey! I could have sworn I’ve been to this blog before but after checking through some of the post
    I realized it’s new to me. Nonetheless, I’m definitely glad I found
    it and I’ll be book-marking and checking back often!

  6. Wow that was unusual. I just wrote an very long comment but after I clicked submit my comment
    didn’t show up. Grrrr… well I’m not writing all that over
    again. Regardless, just wanted to say excellent blog!

  7. I absolutely love your blog and find most of your post’s
    to be precisely what I’m looking for. Does one offer guest writers
    to write content for you? I wouldn’t mind writing a post or elaborating on a
    number of the subjects you write with regards to here.
    Again, awesome web site!

  8. Pingback: projectio
  9. Pingback: psy online
  10. Pingback: bahis siteleri
  11. Pingback: hdorg2.ru
  12. Pingback: Psikholog
  13. Pingback: netstate.ru
  14. Pingback: Link
  15. Pingback: 1treasurer
  16. Pingback: psy
  17. Pingback: bit.ly
  18. Pingback: cleantalkorg2.ru
  19. Pingback: bucha killings
  20. Pingback: War in Ukraine
  21. Pingback: Ukraine
  22. Pingback: viagra
  23. Pingback: site
  24. Pingback: sildenafil citrate
  25. Pingback: stats
  26. Hi there! This blog post could not be written much better!
    Looking at this article reminds me of my previous roommate!
    He continually kept preaching about this. I will send this information to
    him. Pretty sure he will have a great read. Thanks for sharing!

  27. Pingback: Ukraine-war
  28. Pingback: movies
  29. Pingback: gidonline
  30. Pingback: revatio
  31. Pingback: web
  32. Pingback: film.8filmov.ru
  33. Pingback: video
  34. Pingback: filmgoda.ru
  35. Pingback: rodnoe-kino-ru
  36. Pingback: stat.netstate.ru
  37. I’m really impressed with your writing skills and also with the layout on your
    weblog. Is this a paid theme or did you customize it yourself?
    Either way keep up the excellent quality writing, it’s rare to see a great blog like this one today.

  38. Pingback: sY5am
  39. Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet
    my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have
    some experience with something like this. Please let me know if you run into anything.
    I truly enjoy reading your blog and I look forward to your new updates.

  40. Hello! Someone in my Facebook group shared this website with us so I came
    to check it out. I’m definitely loving the information. I’m book-marking and will be tweeting
    this to my followers! Great blog and terrific style
    and design.

  41. Pingback: Dom drakona
  42. Pingback: JGXldbkj
  43. Pingback: aOuSjapt
  44. Pingback: ìûøëåíèå
  45. Pingback: psikholog moskva
  46. Pingback: Dim Drakona 2022
  47. Pingback: TwnE4zl6
  48. Pingback: psy 3CtwvjS
  49. Yesterday, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a 40
    foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has
    83 views. I know this is entirely off topic but
    I had to share it with someone!

  50. Pingback: lalochesia
  51. I do not know if it’s just me or if perhaps everyone else encountering issues with your site.
    It appears like some of the written text in your posts are running
    off the screen. Can somebody else please provide feedback and let me know if this is happening to them too?

    This might be a issue with my web browser because I’ve had this happen before.
    Many thanks

  52. Pingback: film onlinee
  53. Pingback: 3qAIwwN
  54. Pingback: video-2
  55. Pingback: sezons.store
  56. Pingback: psy-news.ru
  57. Please let me know if you’re looking for a article writer
    for your weblog. You have some really great posts and I feel I would be
    a good asset. If you ever want to take some of the
    load off, I’d absolutely love to write some content for
    your blog in exchange for a link back to mine. Please blast me an email
    if interested. Kudos!

  58. I know this if off topic but I’m looking into starting my own weblog and was wondering what all is
    required to get setup? I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very web savvy so I’m not 100% positive. Any recommendations or advice would be greatly appreciated.
    Thank you

  59. Pingback: 000-1
  60. Pingback: 3SoTS32
  61. Pingback: 3DGofO7
  62. Pingback: rftrip.ru
  63. Pingback: dolpsy.ru
  64. Pingback: kin0shki.ru
  65. Pingback: 3o9cpydyue4s8.ru
  66. Pingback: mb588.ru
  67. Pingback: newsukraine.ru
  68. Pingback: edu-design.ru
  69. Pingback: tftl.ru
  70. Pingback: brutv
  71. Pingback: site 2023
  72. Excellent site you have here but I was curious if you knew of any
    user discussion forums that cover the same topics discussed here?
    I’d really love to be a part of online community
    where I can get suggestions from other knowledgeable people that
    share the same interest. If you have any recommendations, please let
    me know. Appreciate it!

  73. Pingback: sitestats01
  74. Pingback: 1c789.ru
  75. Pingback: cttdu.ru
  76. Its like you read my mind! You appear to know so much about this, like
    you wrote the book in it or something. I think that you
    could do with some pics to drive the message home a bit, but instead of that, this is magnificent blog.
    An excellent read. I’ll certainly be back.

  77. Pingback: 1703
  78. Pingback: hdserial2023.ru
  79. Having read this I believed it was extremely informative.
    I appreciate you finding the time and energy
    to put this short article together. I once again find myself
    spending a lot of time both reading and leaving comments.
    But so what, it was still worth it!

  80. Pingback: serialhd2023.ru
  81. Pingback: matchonline2022.ru
  82. Pingback: bit.ly/3OEzOZR
  83. Pingback: bit.ly/3gGFqGq
  84. Pingback: bit.ly/3ARFdXA
  85. Pingback: bit.ly/3ig2UT5
  86. Pingback: bit.ly/3GQNK0J
  87. Pingback: bep5w0Df
  88. Pingback: www
  89. Pingback: icf
  90. Pingback: 24hours-news
  91. Pingback: rusnewsweek
  92. Pingback: uluro-ado
  93. Pingback: irannews.ru
  94. Pingback: klondayk2022
  95. It’s a pity you don’t have a donate button! I’d definitely donate to this brilliant blog!
    I guess for now i’ll settle for book-marking and adding your RSS feed to my Google account.
    I look forward to brand new updates and will share this blog with my Facebook group.
    Chat soon!

  96. Pingback: tqmFEB3B
  97. I’m amazed, I must say. Rarely do I encounter a blog that’s both equally educative and interesting, and
    let me tell you, you’ve hit the nail on the head. The issue is something that too few men and women are speaking intelligently about.
    Now i’m very happy that I came across this in my search for something concerning this.

  98. Fantastic beat ! I wish to apprentice while you amend your website, how
    could i subscribe for a weblog web site? The account aided me a applicable deal.
    I were a little bit familiar of this your broadcast provided shiny transparent idea

  99. I think that is one of the most vital information for
    me. And i am satisfied reading your article. But wanna observation on few common things, The site taste is great, the articles is actually excellent : D.

    Good job, cheers

  100. สล็อต ไม่มี ขั้นต่ํา ฝากถอนไม่จำกัดจำนวนเล่นได้ทั้งวันทั้งคืนกับ PG-SLOT.GAME แหล่งรวมค่ายเกมสล็อตค่ายดังจาก PG SLOT สล็อตออนไลน์ที่ดีที่สุดในปี 2022 สมัครสมาชิกได้แล้ววันนั้

  101. Pingback: mangalib
  102. Pingback: x
  103. Pingback: 9xflix
  104. Pingback: xnxx
  105. Pingback: 123movies
  106. Pingback: kamagra for sale
  107. Pingback: kinokrad
  108. Pingback: batmanapollo
  109. You are so interesting! I do not suppose I have read through anything like that before.
    So good to find someone with genuine thoughts on this topic.

    Really.. thanks for starting this up. This website is one thing that is needed on the
    internet, someone with a little originality!

  110. I loved as much as you’ll receive carried out right here.
    The sketch is tasteful, your authored subject matter stylish.
    nonetheless, you command get got an impatience over that you wish be delivering the following.
    unwell unquestionably come more formerly again since exactly the same nearly very
    often inside case you shield this increase.

  111. Pingback: vsovezdeisrazu
  112. Thanks , I’ve recently been looking for info about this topic for ages and yours is the best I have came upon till now.
    But, what in regards to the conclusion? Are you positive about the supply?

  113. Pingback: 2023
  114. Pingback: ipsychologos
  115. Pingback: yug-grib.ru
  116. Pingback: studio-tatuage.ru
  117. Howdy, i read your blog occasionally and i own a similar
    one and i was just wondering if you get a lot of spam responses?

    If so how do you prevent it, any plugin or anything you can suggest?
    I get so much lately it’s driving me mad so any help is very much appreciated.

  118. Hey there! Thhis iss my first visit tto our blog!
    We aree a collecion oof volunteers and starting a nnew initiatve iin a
    community in the same niche. Yoour blokg provided uss
    useful information too work on. You have done a outstandng job!

  119. Pingback: video.vipspark.ru
  120. Pingback: vitaliy-abdulov.ru
  121. ข่าววันนี้ Pg มีโบนัส ข่าววันนี้ เล่นเกมกับ Pg เกมสล็อตเรามีโบนัสให้เข้ามาเล่นเกม มีเท่าไรเล่นได้ไม่จำกัดมารอโบนัสกับเรามีเเต่ได้กับได้ คุณไม่ผิดหวังได้ผลตอบเเทนทุกเกมชัว

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *