Where’s the address bar?

Posted on by

In Office 2003, you can add address bar (aka Web toolbar) to show you the location of the opened file – whether it is on your hard disk (C:\Documents and Settings\Users\My Documents etc) or on a corporate share drive (\\officeserver\officedocuments\documents). In Office 2007, with the introduction of new menu bar known as the Ribbon, it seems you can’t find the address bar.

Microsoft has the steps on how to add it.

Today, a colleague of mine asked me how to bring back the address bar in Office 2007 – so I’ve decided to share it out here. That’s what I’m going to do moving forward – every time someone asks me a computer-how-do I question – I’ll share it out here – on this website – with an answer, of course.

Like I’ve said in the previous post – I’m out of IT, but IT is not out of me…

But I’m tryin’, Ringo. I’m tryin’ real hard to be the shepherd – Jules Winnfield

Not the hidden cells!

Posted on by

Hidden rows in excel sheet – want to copy and paste some cells / rows to another excel sheet but hidden cells / rows are getting pasted as well; which is something that you want to avoid? There’s no need to send an email to Microsoft yet, here’s what you need to do on MS Office 2007.

  1. Highlight / Select the cells / rows that you want to copy.
  2. Click on Find & Select button (the one with binocular icon) > select Go To Special
  3. Select Visible cells only and press OK.
  4. Press Ctrl+C on the keyboard to copy.
  5. Go to the desire excel sheet and press Ctrl+V on the keyboard to paste.
  6. Correctamundo! Only visible cells will be pasted – not the hidden rows / cells.

via Microsoft.

I’m out of IT but IT is not out of me.

But I’m tryin’, Ringo. I’m tryin’ real hard to be the shepherd – Jules Winnfield