We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Empty cells could play tricks on certain features in Excel, such as pivot tables, that read an empty cell as 0. If we don't want these cells to appear in … [Read more...]
Remove Spaces From Empty Cells
We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes this produces undesired results. Cells that may appear empty really aren't, as they will often times contain spaces. Usually this isn't a problem, but sometimes pivot tables or other … [Read more...]
Create User Forms
Have you ever had a spreadsheet, where you wanted users to be able to enter information in a form, and have it populate the next available row in a given set of columns? It's easier than you thought, and will make entering data more efficient and accurate. The example below will use most of the common UserForm tools to give you a feel for how they work. You can later apply … [Read more...]
Saving Multiple Print Ranges in Excel
Sometimes we setup Excel worksheets so that they flow logically on the screen. Often times they're set up like you would read a book, top to bottom, left to right, but this isn't always the best setup for printing. Suppose you have a spreadsheet with detailed information in the first 50 rows, and then a summary in the next 10. There could be times where you don't care to … [Read more...]
Excel Shortcut Keys
Below, you'll find a fairly comprehensive list of default shortcut keys found on a standard English keyboard in Excel. F1: Help F2: Edit F4: Repeat Action F5: Open Goto Dialog Box F6: Next Pane F7: Spell Check F8: Extend Selection Mode F9: Calculate All F10: Activate Menu F11: New Chart F12: Save As =: Formula Insert: Insert Mode Delete: Delete Active Cell’s … [Read more...]