Helpful Tips for Microsoft Excel
EXCEL: Make a drop-down list to select from
Don’t waste valuable time typing the same data into Excel repeatedly. We’ll show you how to create a dropdown list that will get the job done in no time.
List of Published Articles for Excel Help and Tips
EXCEL: Make a drop-down list to select from
Don’t waste valuable time typing the same data into Excel repeatedly. We’ll show you how to create...
EXCEL: Insert live Excel data into Word
If you need to display data from an Excel sheet in your Word document, don’t waste time trying to...
EXCEL: Make dull data stand out and become dynamic
You may think it impossible to make Excel sheets appear interesting. Well, you’d be wrong. In this...
EXCEL: Save time adding new columns or rows
Adding multiple columns and rows into spreadsheets can be time-consuming, not to mention boring....
EXCEL: Turn numbers into money with one click
If you’re using Excel to track budgets or other financial data, it can be helpful to have your...
EXCEL: Do super-fast sums without formulas
Excel is great for calculations with formulas. But if you find your head spinning trying to...
EXCEL: Speed up typing
Do you find yourself typing duplicate words or numbers into Excel? You can speed up this process...
EXCEL: Instantly see all data in columns & rows
Sometimes in an Excel document the column sizes need to be adjusted so you can see the data...
EXCEL: Get to the top row without scrolling
If your Excel document is very long, it can take a lot of scrolling to get back to the top. Find...
EXCEL: Easily zoom in and out
When you’re looking at data in Excel, make sure you’re looking at the bigger (or smaller) picture...
EXCEL: Always see the headings when scrolling
Excel is great for looking at lots of data, but when you can’t see the column or row headers, you...
EXCEL: Swap rows into columns and vice versa
When you need to swap your rows into columns or columns into rows, it can be tricky. Not only is...
EXCEL: Create ranges of data without doing any typing
If you need to create sequential numbers, dates, or other data in Excel, it can take forever. Not...