Keep your Format Painter Active

  • 28 June 2016
  • Author: Anonym
  • Number of views: 1000
  • 0 Comments
Keep your Format Painter Active
The Format Painter button offers a great service. It copies the formatting from your selected cell or data range and pastes it onto the next data range you select. You don't have to format a new area — including font, borders, number formats, etc. — from scratch.

Use the Calendar Control on your VBA Forms

  • 6 June 2016
  • Author: Anonym
  • Number of views: 1356
  • 0 Comments
Use the Calendar Control on your VBA Forms
One way to avoid date validation routines on your VBA forms is to use the Calendar control, which looks just like a calendar. A user can choose a date by simply clicking on that date on the Calendar control. To add the Calendar control to a user form, you first have to add the calendar control to your Control toolbox.

Get more Versatility from AutoFill

  • 31 May 2016
  • Author: Anonym
  • Number of views: 1209
  • 0 Comments
Get more Versatility from AutoFill

If you perform a lot of data entry, then you probably use Excel's AutoFill feature to save time and fill a series in your spreadsheet. By default, the Fill handle creates a series from lowest to highest, or ascending order. But, if you want a series to extend from highest to lowest, or descending order, it's a snap to do.

Convert a 1-D Object into a 3-D Object Quickly

  • 24 May 2016
  • Author: Anonym
  • Number of views: 1156
  • 0 Comments
Convert a 1-D Object into a 3-D Object Quickly
Excel 97 offers many new drawing features. Now you can change a one-dimensional object into a 3-dimensional object quickly and easily. Not only can you make it 3-D, but also you can choose the angle and shading of the object. Start by selecting the object and selecting the 3-D tool (which looks like a 3-D box) located on the drawing toolbar. On the 3-D tool box there are 20 different angles to choose from. At the bottom of the toolbox the 3-D Settings option appears. If you choose it, you can change the lighting, the surface, and many other attributes. After you choose your 3-D option, you will see that the object you have selected now appears in 3-D.

Creating Your Own Formatting Style

  • 16 May 2016
  • Author: Anonym
  • Number of views: 1139
  • 0 Comments
Creating Your Own Formatting Style
If you've ever wanted to create a formatting style that's different than any of the currently available styles, you'll be glad to know that there's an easy way to do it. First, select the cell that has the combination of formats that you want to include in the new style. Then, choose Style from the Format menu and in the Style name box, type a name for the new style. To define and apply the style to the selected cells, click OK. To define the style without applying it, click Add, and then click Close. Also, if no cells have the formats you want for the style, you can specify the formats when you name the style.

Using Styles – Format Collections

  • 9 May 2016
  • Author: Anonym
  • Number of views: 5052
  • 0 Comments
Using Styles – Format Collections
Apply a set of built-in styles or create custom styles for quick and consistent formatting. An automatic table of contents may be created from built-in styles.

How to Determine the Amount of Data in a Worksheet

  • 2 May 2016
  • Author: Anonym
  • Number of views: 1108
  • 0 Comments
How to Determine the Amount of Data in a Worksheet
By pressing Ctrl+End, the active goes to a particular location on the screen. There is no data anywhere below this row in this worksheet, there's no data to the right of that column anywhere. So you can see the actual figures of how much data you have or for instance, count the number of rows containing data. And the opposite of Ctrl+End is Ctrl+Home.

Faster Way to Get Back and Forth Between Different Files

  • 2 May 2016
  • Author: Anonym
  • Number of views: 1212
  • 0 Comments
Faster Way to Get Back and Forth Between Different Files

A faster way to get back and forth between different files, in fact different workbooks is Ctrl+Tab back and forth. Now, when you have only two files open, that's particularly fast. If you have a third file open, Ctrl+Tab takes us to the next one, the next one and then back to the current one and so on. So the more files you have open, the less efficient that is. But nevertheless, it's still a reasonable easy thing to want to get to, that idea of switching between open workbooks.


RSS
1234

Categories