Using the Split feature allows you look at different parts of an Excel worksheet at the same time.
Archive for category General Tips
Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen. This month I’ll show you how you can choose rows or columns to appear on every page when you print.
Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.
Text copied or imported onto a spreadsheet may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Excel doesn’t have a Change Case button like Word does, but you don’t have to copy your text to Word to change case and copy it back. Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.
Many times on a project you have the right data, but in the wrong format. In this tip I’ll show you how you can break apart a single column of data into two or more columns in Excel using the Text To Columns feature.
If you need to calculate a date in Excel based on another date, such as a due date that is 30 days after an invoice date, or scheduling a follow-up 3 months after a meeting, you can do so using a simple formula to add a number of days to a date, or using the EDATE function to get the same date in a future (or past) month.
Learn how to rank list entries in Excel without resorting your data.
A watch window lets you monitor cells from different parts of a spreadsheet all in one spot.
If you have ever needed to shut down Windows 7 in a hurry only to discover updates waiting to install, this is the tip you’ve been waiting for.
See how to easily copy or move tab within or between workbooks.