Software-OK
≡... News | ... Home | ... FAQ | Impressum | Contact | Listed at | Thank you |

  
HOME ► Faq ► FAQ - Microsoft-Office ► ««« »»»

Define the print area in the MS Excel table before printing!


Specifying the print area in the MS Excel spreadsheet before printing is a handy function in MS Office !



In order to print only certain table areas, the print area print is very useful and can also be used by inexperienced MS Office users to avoid having to print complete tables if only certain sections are required! 
 
Contents:

1.) ... Defining the print area in the MS Excel spreadsheet!
2.) ... Adjust the print area for classic MS Excel!
3.) ... More information about printing in MS Office!



1.) Defining the print area in the MS Excel table!

1. As always, open your MS Excel document 

2. Highlight the area of text to be printed

3. Go to the first cell, hold down the Shift key

4. While holding down the Shift key, use the arrow keys  to highlight the print area

5. After marking, simply go to   "Page layout"  ►  "Print Area"  ► Set  print area 

6. Then simply print the print area via the Print page "File" ► "Print"

(... see Image-1 Point 1 to 6) 

PS:
If the print area is no longer required, simply deactivate it again via  " Page layout"  ►  "Print area"  ► Clear print area !

Addendum:
To specify multiple print areas, you can hold down the Ctrl key after marking and specify additional print areas!

(Image-1) Define the print area in the MS Excel table before printing!
Define the print area in the MS Excel table before printing!

-
▲ Back to the top ▲




2.) Adjust the print area for classic MS Excel!

In essence, adjusting the MS Excel print area is the same as described in point one! Here in the example on MS Office Excel 2002!  

1. Menu ► File ►  "Print range"  ► Specify  print range 

2. And simply click on print afterwards 

(  ... see Image-2 Point 1 to 3 )  

(Image-2) Define the print area classic in MS Excel table!
Specify the print area in the classic way in MS Excel spreadsheets!

-
▲ Back to the top ▲


3.) More information about printing in MS Office!

A user-defined print area is a popular function in MS Office Excel to only print certain areas and is very useful to exclude areas that are not required and to waste space on the sheet, thus also saving paper and of course also environmentally friendly!


See also:

►►  Delete a blank page in Microsoft Word (do not print)!
►►  How to print only the selected text in Office Word?
►►  How can I print everything on one page in Excel?







FAQ 62: Updated on: 2 September 2022 17:18 Windows
Microsoft-Office

Reduce margins and headers before printing Office documents!


Its easy to reduce page margins and headers before printing Office documents MS Excel, Word, Especially if you ►  want to print everything clearly
Microsoft-Office

How can I insert a transparent image in MS Word?


In MS Word, its easy to insert an image or graphic and make the image transparent or blurry is suitable for MS Paint, Excel as a solution 1. Insert
Microsoft-Office

Does MS Office 2000 / XP work on MS Windows 11, 10, ...?


Office 2000 32 bit works in my test on Windows 11 and 10, so 2003, . 2010 should work too  Here is a screenshot of MS Excel 2000 on Windows 11   PS:
Microsoft-Office

Insert watermark in MS Word or Excel?


Its quite easy to insert a watermark in MS Word or Excel in MS Office to adjust the color and size of the watermark Easily make watermarks for paper printing:
Microsoft-Office

Can I install the old MS Office on Windows 11, is this  better?


Yes you can just install and use the old MS Office on Windows 11, 10, why not 1. Example of MS Office XP 2002 on Windows 11 2. Can old MS
Microsoft-Office

Create sublines in Word even without text!


Very popular are sublines, also known as underlines in Word, which can also be displayed without text to separate areas in the text Everyone probably knows
Microsoft-Office

How do I use 3-D text in Office presentation or document?


Using 3-D text is very popular in Office presentations or documents, whether its PowerPoint, Word or any other MS Office document   Everyone is probably

»»

  My question is not there in the FAQ
Asked questions on this answer:
  1. Can I add more cells to the print area after I set it up?
  2. Do I have one or two ways to adjust print area in Excel workbook?
  3. How do I set the print area in Microsoft Excel?
  4. Include cells in print area setup with add page layout as print area option?
  5. Where do I set a print area in Excel?
  6. I often need to print a specific part of the Excel spreadsheet, what can I do in Microsoft Excel to select a specific print area?
  7. Can I set one or more print areas in the same Excel spreadsheet?
  8. In the Page Layout tab, find the Print Area option in Excel?
  9. After you have defined a print area in your Excel spreadsheet, do I want to continue automatically setting the print area in the workbook?
  10. Where to select the print area for MS Office Excel?
  11. Print additional cells as a separate print area on the Excel sheet?
  12. Want to resize a current print area to accommodate more cells in Excel?
  13. Hold down the Ctrl key and then select the cells in MS-Excel?
  14. I have to select every time I want to print where do I set a print area in Excel?
  15. Need help multiple print areas on my sheet Ctrl key pressed while using group of cells select?
  16. Print area set up with correct cells set for a sheet in MS Office Excel?
  17. How do I view the print area, or add cells to a print area?
  18. Want to set a single print area using cells in Excel page layout?
  19. Can I delete a print area in MS Excel in a print preview?
  20. I want to add cells to a print area on a sheet in MS Office Excel?
  21. How to see the print area on Excel?
Keywords: microsoft, office, define, print, area, excel, table, before, printing, spreadsheet, function, certain, areas, Questions, Answers, Software




   

  + Freeware
  + Order on the PC
  + File management
  + Automation
  + Office Tools
  + PC testing tools
  + Decoration and fun
  + Desktop-Clocks
  + Security

  + SoftwareOK Pages
  + Micro Staff
  + Freeware-1
  + Freeware-2
  + Freeware-3
  + FAQ
  + Downloads

  + Top
  + Desktop-OK
  + The Quad Explorer
  + Don't Sleep
  + Win-Scan-2-PDF
  + Quick-Text-Past
  + Print Folder Tree
  + Find Same Images
  + Experience-Index-OK
  + Font-View-OK


  + Freeware
  + Delete.On.Reboot
  + IsMyTouchScreenOK
  + Print.Test.Page.OK
  + OpenCloseDriveEject
  + ColorConsole
  + IsMyLcdOK
  + DesktopDigitalClock
  + ClassicDesktopClock
  + PreventTurnOff
  + PAD-s
Home | Thanks | Contact | Link me | FAQ | Settings | Windows 10 | English-AV | Impressum | Translate | PayPal | PAD-s

 © 2025 by Nenad Hrg softwareok.de • softwareok.com • softwareok.com • softwareok.eu


► How long does it take to download Windows 12? ◄
► How to Repair Paralyzed Pixels on an LCD Monitor? ◄
► The best printer tips for Windows 11? ◄
► Quad-Directory-Explorer 3.31 and Windows 98 on 10? ◄


This website does not store personal data. However, third-party providers are used to display ads,
which are managed by Google and comply with the IAB Transparency and Consent Framework (IAB-TCF).
The CMP ID is 300 and can be individually customized at the bottom of the page.
more Infos & Privacy Policy
....