Geeky Ch1ck

Geeky stuff

Save all open files in Word 2007 at the same time [Tip] December 8, 2009

Filed under: Office 2007,tips and tricks,Windows,Word — Geeky Chick @ 17:51
Tags: , ,

I have been trying out the Office 2010 beta. I like it but it’s not so different from Office 2007 that I’d consider forking out for an upgrade.

So, instead I’m honing my 2007 skills as it looks like I’m going to need them for a while longer…

Although it is not possible to save all open documents in Word 2007 the ‘old way’ (ie by pressing Shift and selecting ‘Save all’ from the menu bar), you can add that command to the Quick Access Toolbar.

  1. Click the Office button (top left)
  2. Click ‘Word Options’ bottom right
  3. Click Customize (about 6th option down in the left hand panel)
  4. Click the small arrow next to the’ Choose Commands From’ box (it will probably be on its default of ‘Popular Commands’) and choose ‘Commands Not In Ribbon’
  5. Scroll down and click on ‘Save All’
  6. Click the Add button (in between the two main boxes, in the middle of the window)
  7. Click the up arrow (far right)  if you want to change the position of the command on the Quick Access Toolbar
  8. Click OK.

And you’re done. Now just click the icon to Save All open documents.


Get Excel to read your data back to you July 16, 2008

Filed under: Office 2007,tips and tricks,website — Geeky Chick @ 16:11

It’s always such a nightmare entering loads of figures into an excel spreadsheet and then having to try and check the figures are right, isn’t it?

Did you know Excel can READ the data (numbers and words) back to you so you can manually check the original data? Nor did I until I read the latest tip from tech-recipes.

Here’s what they say to do:

  1. Open Excel 2007 and go to the Quick Access Toolbar at the top of the window.
  2. Click the downward point arrow to the right of the toolbar and select More Commands.
  3. From the dropdown menu, select Commands Not in the Ribbon.
  4. Scroll down the list and find Speak Cells, Speak Cells — Stop Speaking Cells, Speak Cells by Columns, Speak Cells by Rows, and Speak Cells on Enter. Add each of these by selecting them one-by-one and clicking the Add button. Click OK after all 5 commands have been added.
  5. Now go to your spreadsheet and select the cells you want Excel to read by performing a simple click and drag. Once the data is selected, go to the Quick Access toolbar and select either Speak Cells by Columns or Speak Cells by Rows. When you are ready for Excel to begin reading off the data contained in the selected cells, select Speak Cells and Excel will begin reading out the data to you.
  6. If you need Excel to stop reading, simply select Speak Cells – Stop Speaking Cells.

Admittedly having all those items on your quick access toolbar is a bit clunky, but you can always remove them, I suppose?


'Search commands' for Office 2007 July 10, 2008

Filed under: Office 2007,tips and tricks — Geeky Chick @ 16:59
Tags: , ,

I have been using the Microsoft Office Labs ‘search commands’ for a while now and it’s a pretty useful tool when you just don’t know how the heck to do something in Word, Excel or PowerPoint 2007.

You can download an additional tab for your ‘ribbon’ that gives you a search box to type in your query and it magically tells you how to do what you need to do. Just click on the result you want and it does what you need it to do.

Problem is, it doesn’t tell you HOW it did it, so you don’t get to learn anything. Can’t have everything, I suppose.

Simply go to the Office Labs search command page and download the .msi file, run it and next time you open Word, Excel or PowerPoint the last tab on your ribbon will be the ‘Search commands’ tab.

Search command from Microsoft Office Labs

Search command from Microsoft Office Labs


How to convert a table to text in Word 2007 June 18, 2008

Filed under: Office 2007 — Geeky Chick @ 12:45

I couldn’t for the life of me work out how to do this. I’d found out how to convert text to table pretty easily: select text, click on the ‘Insert’ tab, click the down arrow under ‘Table‘ and select the option to ‘Convert text to table‘. But how to do it the other way round?

Here’s what you do (taken from Word 2007 help):

  1. Select the rows or table that you want to convert to paragraphs.
  2. Under Table Tools, on the Layout tab, in the Data group, click Convert to Text.
  3. Under Separate text at, click the option for the separator character that you want to use in place of the column boundaries (eg tab).

Selecting tip for Word June 13, 2008

Filed under: Office 2007,software — Geeky Chick @ 14:30

I can’t believe I’ve only just found this out, but did you know that you can select words and paragraphs in a Word document THAT AREN’T NEXT TO ONE ANOTHER by using the CTRL key?

So, in the example below I double clicked ‘providing’ then held down the CTRL key and double clicked ‘engineering’.

Now you can do what you like with them: delete them both at the same time, change the font, make them capitals…you name it. And it works with whole paragraphs too.

This works for Word 2007. Not sure about earlier versions.