Posts

Showing posts with the label Print Area

Take the print out of your spread sheet the way you want.

Image
  Introduction It is a common workplace issue that people face when they take the print out of their neatly created Excel sheet only to find out that one or more columns of their Excel sheet have exceeded the margin of the A4 sheet. It is frustrating and also leads to the wastage of paper.   Excel automatically divides your sheet into separate pages for printing based on margin settings, scaling option, paper size etc. without any regard to the number of columns or rows you may be having. As the number of columns of your sheet increases, it becomes more likely that your sheet will not print the way you want i.e. all columns in one page or all rows in one page. People try many ways to work around this by changing the Font Size, manual resizing of Cell width, applying Landscape orientation to accommodate more columns in one page etc. But sometimes, even after these adjustments the sheet just doesn’t fit in one page. Also, it doesn’t increase your productivity if you are doing such