Posts Tagged ‘spreadsheets’

Open Multiple Files at Once in MS Office

Friday, February 27th, 2009

I am a multi-tasker. I almost always have several applications open at any one time, for instance, when I am creating my newsletter! So, in the interest of saving time, I usually open all of these documents, spreadsheets, etc. all at once.

Follow the steps below to learn how:

  1. Click on File | Open, or in 2007, click the Office button and Open. You can also use the keyboard shortcut CTRL + O.
  2. Find the files you would like to open.
  3. If the files are contiguous, click on the first one to highlight it and then depress your Shift key and while still holding it down, click on the last item in your list.
  4. If the files are NOT contiguous, simply click on the first one and then depress your CTRL key and keep it held down while you select your other files.
  5. Once you have selected your files, click on Open.

NOTE: These files must all reside in the same folder for this method to work.

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

Put Checkmarks in your Cells in MS Excel

Tuesday, February 3rd, 2009

I receive lots of e-mail from subscribers asking me if they can put checkmarks into the cells in their MS Excel spreadsheets. The short answer is yes!

There are several ways to place checkmarks in the cells of your MS Excel spreadsheets. Follow the steps below to learn how:

Note – Depending upon your version of MS Excel and Windows, you may not have some of the fonts below.

  1. Type a lower case a and change the font to Marlette or Webdings.
  2. Type an upper case P and change the font to Wingdings2.
  3. Hold down the ALT key and type 251.
  4. Click on Insert | Insert Symbol and scroll down and click on the checkmark. Click on Insert | Close | Enter.
  5. Hold down the ALT key and type 0252 and change the font to Wingdings.

You may also insert a CheckBox in your worksheet by following these steps: 

  • Click on View | Toolbars | Forms.
  • Select the CheckBox icon and click where you would like to place the CheckBox in your spreadsheet.

You can also change or delete the CheckBox label or resize or move it.

To make a copy of the CheckBox, hold down your CTRL key while dragging the border of the CheckBox.

Now you have lots and lots of choices to place checkmarks into your spreadsheets!

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