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 

(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: 14 May 2022 16:02 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 1. Insert an image file into MS Office Word and the options
Microsoft-Office

How to selecting multiple pieces of Text in MS-Word?


The solution to select multiple text pieces of Text can be very helpful, when editing the Text in MS-Word. Please select the first section of the text
Microsoft-Office

How to select multiple non sequential Rows of Text in MS-Word?


The solution is simple to select multiple non sequential Text Rows in MS-Word If you want to select multiples not sequential Text Rows in MS-Word
Microsoft-Office

Outlook 2016 I receive the error message, not an .ost file!


Suddenly when try to run Outlook, I get an error message the OST file and when click OK, the error message is closed Please read this: ►   Outlook 2016
Microsoft-Office

MS-Excel can calculate Euro or US Dollar sum, but how?


Quite simply it is in MS-Excel Euro or US $ sum to calculate, here a simple example Formulas and functions are the strongest tool in Excel. Even complicated

»»

  My question is not there in the FAQ
Asked questions on this answer:
Keywords: microsoft, office, define, print, area, excel, table, before, printing, spreadsheet, function, certain, areas, Questions, Answers, Software




    

  + Freeware
  + File management
  + Decoration and fun
  + Automation
  + Office
  + Order on the PC
  + PC testing tools

  + 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
  + DesktopNoteOK
  + ShortDoorNote
  + AutoHideDesktopIcons
  + BlankAndSecure
  + AlwaysMouseWheel
  + NewFileTime
  + DesktopClock3D
  + PointerStick
  + DesktopImages3D
  + PAD-s


Home | Thanks | Contact | Link me | FAQ | Windows 2021 | Windows 10 | English-AV | Impressum | Translate | PayPal | PAD-s

 © 2022 by Nenad Hrg softwareok.de • softwareok.com • softwareok.com • softwareok.eu
0.078


► BitLocker in Windows 11 start menu or on the desktop as a shortcut! ◄ ► Open Advanced System Setting in Windows 11 or 10 (three solutions)! ◄ ► Can I continue to delete files at restart under Windows 11? ◄ ► How to change Screen Resolution in Windows 10? ◄ ► URL redirection modules for Windows Server 2019, 2016, ...! ◄ ► What is PowerShell? ◄ ► Download Free alternative command prompt for Windows 11, 10, ...! ◄ ► Explorer 4 X for all Windows 11, 10, ... etc. User, Admins and Novice! ◄
This website uses cookies to ensure you get the best experience on our website more Infos & Privacy Policy
....