subject: Best Guide to Microsoft Excel Secrets - The Excel Addict Review [print this page] Best Guide to Microsoft Excel Secrets - The Excel Addict Review
Format Painter
Excel is a program in which formatting the visual characteristics of information is a common task. Its tools to change colors and font, add borders around cells, shade the background, enlarge text and apply attributes like bold, italics and underline, make reading spreadsheets more interesting and clear, drawing the attention easily to different categories and other information.
The Format toolbar offers the features to create these changes. You can often use many tools to regulate just one cell or group of cells. Should you add new cells later, rather than repeating the same process for identical format settings, simply use the "Format Painter" button copying a format and put it on to another cell. Click on any cell that's already formatted as you like. Click on the "Format Painter." Then click on any other cell. These three clicks are that's essential to make the new cell look exactly like the first.
The Fill Handle
Copying and pasting is a common task in Excel. So is the process of creating lists of information, such as a column having a numerical list that counts from "1" to "100" or a list of days of the week that goes on for months. It will take a long time to type all of this manually, or even to use a copy-and-paste technique to get the data to the spreadsheet.
The "Fill Handle" is really a useful little tool that lots of users have no idea. Any selected cell in Excel includes a black border around it. On the lower right corner of the border is tiny black square---the fill handle. With just one cell selected, click on this handle and drag it any direction. All cells as part of your mouse movement will be filled in with similar instructions as the original cell. Before you choose multiple cells which contain a pattern, the fill handle will continue and repeat this pattern into all cells over which you drag it.
For example, if you have three cells that say "January 1," "April 1" and "July 1" for that first day's each quarter, select these cells and drag the fill handle further on the next paragraphs. Excel will automatically create other date cells which complete this pattern, adding "October 1" after which starting over again with "January 1" as far as you care to drag. Many years' worth of start-of-quarter dates can be added in seconds.
Inserting Rows
There are many ways in Excel to insert multiple rows. Many users do not realize that they can insert several rows with just one click.
In order to insert 10 new rows between rows 20 and 21, just click about the row number 21 and drag down 10 rows to row 30 so 10 rows are highlighted. Then right-click on any of these row numbers and pick the "Insert" command. Instantly 10 new rows are inserted between your two rows. What was once row 21 is now row 31. The same technique can be utilized for inserting multiple columns.
Now, let's talk about The Excel Addict created by Francis Hayes and just how it may assist you. I hope this short The Excel Addict Review will aid you to differentiate whether The Excel Addict is Scam or perhaps a Genuine.
Microsoft Excel is a complex spreadsheet application with extended features. Data is entered in columns and rows, and then the program can use built-in tools or custom formulas to investigate and chart the data . You will find often multiple methods in Excel to accomplish the same result. Some of Excel's most efficient features aren't obvious, and several users can go years not understanding these secrets.
These Tips Can easily and Dramatically Improve your Productivity in Excel. I have been using Microsoft Excel for over Fifteen years and the more I use it, the greater it amazes me. So, I started my very own website and newsletter and wrote this ebook to share all the amazing tricks which i have discovered. Once you uncover just a few tips from a seemingly unlimited supply of amazing, almost-magical Excel secrets, you will understand why so manypeople become 'addicted' to Excel.
