When you have a spreadsheet that's chock full of numbers and statistics that's hard for your audience to interpret, you can have Excel create a chart from your data to better convey the meaning behind the numbers.
But what kind of chart should you choose? Which one will work best with the data you've got?
Printing from Excel can be frustrating if your spreadsheet is too wide or too tall to fit on a single page. If those last few columns or rows print on a second page, it makes the info harder to digest.
One option is to use the "Fit Sheet on One Page" command from the scaling drop-down menu to shrink the page — but that can make your spreadsheet way too small to read.
Instead, watch this 3-minute video to see Mary Sanseverino demonstrate a different way to print your large-ish spreadsheet on a single page:
It must be the wintery weather — my mind is on freezing things.
When you freeze a pane on an Excel spreadsheet, you're keeping a row or a column still while the rest of the cells below it can scroll freely. This step lets you view your column and row headings continuously while you scroll your document. This is great when you have a spreadsheet with enough data that you have to do a lot of scrolling to see all the cells, then lose track of the headers that label the columns.
Take 15-minutes to watch this demo to learn...
How to freeze & unfreeze rows and columns
How to print frozen rows or columns
The difference between freezing panes, locking cells, and splitting the window
Other tips that let you see and work with data more easily
When you create a new Excel file, it contains three worksheets — they show as small tabs at the bottom of a worksheet. Each tab has a name, like Sheet1, Sheet2, an so on. You can see the data stored on each worksheet by clicking the tab of the sheet you want to view.
Renaming a worksheet or changing the color of the worksheet's color makes it easier to organize and keep track of the data you've created.
It's easy to get lost in spreadsheets — if data fills lots of rows or columns, when you scroll down or across you lose sight of column or row headers, and then information loses its meaning.
Freeze Panes can help by letting you view column and row headings continuously, while you scroll your document. It lets you keep a row or column still, while the rest of the cells around it can scroll freely.
Computer crash? Power went out during a storm? And you were in the middle of editing a budget spreadsheet and didn't get a chance to save your work? Ugh.
Microsoft Office programs (which include Word, Excel, PowerPoint) are by default set to automatically save an open file every 10 minutes. So when you re-open the program, your file should still have all the changes you have made — except for the last 10 minutes of work. (Your file may retain more recent changes if you manually saved it yourself by pressing Control+S on the keyboard.)
10 minutes between autosaves not good enough for you? Me neither. Here's how to better protect your hard work: