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...]
How to Create a Calendar in Excel
It's always useful to have a calendar in Excel. Having one lets you save it on a shared network drive, so everyone involved in a particular project knows what's going on and important dates coming up. Creating a calendar in Excel can be a tedious task if done manually. Thankfully, using the Visual Basic Editor, you can easily create a calendar in Excel. By creating a simple … [Read more...]
Install and Use Macros
So you've found the perfect macro code to speed up that tedious and repetitive task - now what? In this section, we'll walk you through the several ways to install and use your macro code. We'll show you how to get comfortable with macros in excel before moving on to move on to perform more complex tasks. Once you know how to use macros in Excel you will have the ability to … [Read more...]