Simple

#2 Tip a Day: Ctrl + 0

#2 Tip a Day: Ctrl + 0

This tip is # 2 in a series of a Tip a Day for December 2015. Tips range from the obvious to the simple to some more complex tips. Hopefully there is something you find helpful!

If you’re working with spreadsheets that stretch out to the right beyond the current frame, chances are you jump out to the right a fair bit. Usually, this is done by positioning the active cell on a row with data, using control->arrow to jump to the end of the row’s data.

To save a little time, if you go one column to the right of your most right-hand data, control->arrow to the right and then press Ctrl+0, all columns to the right will be hidden. They’re blank anyway, so you don’t need to hide them. Now, you can get to the most right-hand column from anywhere, not just rows with data.

This tip will only save you small amounts of time per use. But over time, those time savings will add up!

P.S. You can also do the same with the rows below the bottom used cell using Ctrl+9

#1 Tip a Day: Prevent Excel Automatically Creating Hyperlinks

#1 Tip a Day: Prevent Excel Automatically Creating Hyperlinks

This tip is # 1 in a series of a Tip a Day for December 2015. Tips range from the obvious to the simple to some more complex tips. Hopefully there is something you find helpful!

Does it annoy you when Excel automatically creates hyperlinks to anything that looks like a web address? When you first hit enter on the cell after inputting the address, you can press Ctrl+z to undo the insertion of the hyperlink. However, if you’re after more than a piecemeal approach, and want Excel to stop doing it all together, here’s how you do it.

  1. Go to File -> Options -> Proofing
  2. Click the “AutoCorrect Options…” button
  3. Go to the “AutoFormat As You Type” tab
  4. Untick the top radio box: “Internet and network paths with hyperlinks

Note, this tip also works with Word!