Posts Tagged ‘drag’

« Older Entries

Adjust Column Width and Row Height in MS Excel

Monday, February 6th, 2012

This may seem to you to be a very basic tip but there are always folks out there who can benefit from this information and this is for them!

  1. To adjust your column width, select the column you want to adjust and simply drag the vertical bar between any two columns to the width that suits you.
  2. You can also double-click that same vertical bar and the columns will automatically fit to the widest entry in each column.

The same applies for adjusting row height in Excel.

  1. Select the rows you want to adjust and drag the horizontal bar between any two rows to the desired row height. If you double-click on that same bar, Excel will automatically adjust the rows to the best fit.
  2. If you want to have your column width adjusted based ont he widest entry in part of the column, select the area where you want the column width based on and click on Format | Column | AutoFit Selection.

Tags: , , , , , , , ,
Posted in Excel 2003, Excel 2007, Excel 2010, Microsoft Office Excel | No Comments »

Add Menu Items in MS Excel

Thursday, April 21st, 2011

It doesn’t bother some folks to keep re-inventing the wheel, but for us power users, we want to streamline things so that we can save time and keystrokes.  Isn’t that the whole point of using the Microsoft Office Suite?  It is supposed to make life easier for us and save time and it can absolutely do that.  We just have to set it up to do our bidding.

If you find that you are always clicking around to find something that you do fairly frequently in your worksheets, it is time to customize things to save time. For instance, using macros.

Follow the steps below to learn how:

  1. Click on Tools | Customize.
  2. Be certain the Commands tab is selected.
  3. In Categories, select either the category of commands you would like to add to your menu, or select Macros if you would like to add a macro to a menu.
  4. In the list of available commands for the category, select the one that you would like to add to a menu.
  5. Drag your selected command to the menu where you would like it added.
  6. The menu appears as you move the selected command over the command name.
  7. Once you have reached the point where you would like your item to be added, release your mouse button.

Life will now be much simpler for you!

Versions 97, 2000, 2002, 2003

Tags: , , , , , , , ,
Posted in Excel 2003, Microsoft Office, Microsoft Office Excel, Office Productivity | No Comments »

Move your Table Quickly

Wednesday, April 20th, 2011

For those of you who love to save keystrokes and time, this is the tip for you!

Did you know that in most versions of MS Word you can use your mouse to quickly and easily move your entire table within your documents?  Well you can!  Everyone knows I am the queen of saving time and keystrokes, so I thought I would share this with those of you who weren’t aware of this nifty little feature.

Follow the steps below to learn how:

  1. Hover your mouse over your table. You do not have to click, just hover. When you do you will see in the upper left corner of your table, a small icon that looks like a square with a four headed arrow inside it.
  2. When you click and drag the icon your table moves with it.
  3. Once you have reached the spot in your document where you would like your table to appear, simply release your mouse button and your table has now been repositioned!

Cool beans huh?

Tags: , , , , , , , ,
Posted in Microsoft Office, Office Productivity, Word 2003, Word 2007, Word 2010 | No Comments »

« Older Entries