Printing a spreadsheet that has many rows and columns can be a challenge. Before you print, you can quickly rearrange page breaks to define what will be printed on each page. Your printout will look just right, and no paper will be wasted on bad printouts or blank pages. This short video demonstrates how you can use Page Break Preview to drag to easily drag page breaks to precisely the spot you want them.
You've compiled a big, complicated spreadsheet full of numbers and you want the important ones to stand out. Give conditional formatting a try - it's an Excel technique that changes cell appearance based on rules you set up, like "Turn the cell green if its value is less than 100."
How do I change the default font for things like page numbers, headers, footers, footnotes, and endnotes?
These are all styles. You can change the attributes of any style for the current document or for all documents based on the current template. If the current template is the Normal template and you select the Add to template option below, all of your ordinary new documents will reflect the style changes that you make.
Microsoft Excel and Word allow you to split the screen to give you different views into the same document or spreadsheet. The first thing to look for, to see if your program offers this feature is a tiny spacer next to the scrollbar. There may be one above the vertical scrollbar.
There may be one to the right or left of the horizontal scrollbar.