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."
When you click Excel's AutoSum button from a cell next to a row or column of numbers, Excel automatically sums those numbers.
You don't have to type a formula (=sum()) or drag through the cells. Excel figures out what's needed and adds the precise summing you need.
Now here's the really nice part. There's a keyboard shortcut that lets you do this without having to change your focus from the worksheet to the toolbar.
In Windows, just press the Alt key and = (the equal sign).
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.
If you look at the upper-right corner of your spreadsheet above the scroll bar, you'll notice a small bar:
Click and drag this bar down. You will see a gray bar move up and down when you move your mouse. Let go when it's where you want it. Now that section will not move when you scroll up and down.
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.