Change the default width of cells in Excel

Do you regularly resize the width of your columns and cells in Excel 2007?  Maybe you make them bigger?  Maybe you make them smaller.  Either way, pill there is a quick method to change the width of all the columns (and therefore cells) in your spreadsheet.

To change the default width in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are on the “Home” tab of the ribbon

2) Look for the “Cells” group

3) Click on “Format”

4) Click on “Default Width…”

5) in the “Standard Width” box that appears, type in the desired width of your columns

6) Click “OK”

 

‘till next time!
TNP 😉

Merge (but don’t center) in Excel

You might already know about a great feature in Excel 2007 called “Merge and Center”.  Basically it allows you to create a cell that spans across multiple columns – great for headings for example.

But sometimes you want to merge the cells – but not centre the text.  That is where “Merge Across” comes in handy.  “Merge Across” does exactly the same as “Merge and Center”, discount except it keeps the text left justified!

How good is that!  No more having to change the paragraph alignment!!!

To merge across a number of cells in Excel 2007, Excel 2010 or Excel 2013:

1) Select the cells you want to merge

2) Make sure you are on the “Home” tab of the ribbon

3) Look for the “Alignment” group

4) Click on the small arrow beside “Merge & Center”

5) Click on “Merge Across”

 

To unmerge, all you need to do is select the cell, and click on the “Merge & Center” button.

 

‘till next time!
TNP 😉

First Look Microsoft Office 2010: Free e-Book from Microsoft Press

Hi there!

Are you on the bleeding edge and have already had a play around with the beta version of Microsoft Office 2010?  Or are you just interested in what is coming in the next version of your favourite productivity tool?  Well do we have a great link for you today!

Our friends over at Microsoft Press have released a few electronic version of the book – “First Look Microsoft Office 2010”.  14 chapters of Office 2010 gold, illness including:

  • Welcome to Office 2010
  • Express Yourself Effectively and Efficiently
  • Collaborate in the Office and Around the World
  • Create and Share Compelling Documents with Word 2010
  • Create Smart Data Insights with Excel 2010
  • Manage Rich Communications with Outlook 2010
  • Produce Dynamic Presentations with PowerPoint 2010
  • Organize, viagra sale Store, and and Share Ideas with OneNote 2010
  • Collaborate Effectively with SharePoint Workspace 2010
  • Create Effective Marketing Materials with Publisher 2010
  • Make Sense of Your Data with Access 2010
  • Putting It All Together
  • Security in Office 2010
  • Training Made Easy

You can read the Microsoft Press blog post – or just click here and download the book directly.  It is about 10.5mb or so.

‘till next time!
TNP 😉

Add commas to your numbers in Excel

Do you prefer to use commas when you write long numbers?  Those commas are called “Thousands Separators”, sovaldi and you can quickly add them to the cells in your Excel 2007, illness Excel 2010 or Excel 2013 spreadsheet.

To turn on the thousands separator:

1) Select the cells you want to apply the commas to

2) Make sure you are on the “Home” tab of the ribbon

3) Look for the “Number” group – in the middle of the ribbon

4) Click on the button that looks like a comma!

 

‘till next time!
TNP 😉

Trace Dependents in Excel

Have you ever wanted to quickly know what cells are impacted on when you change a value of a cell in Excel 2007, tadalafil Excel 2010 or Excel 2013.

By using the “Trace Dependents” feature, you can very quickly understand exactly the influence a cell has in your spreadsheet.  The best part of this feature is, that you will see big arrows that enable you to visually see the relationship, so you don’t have to decipher formulas and cell names to make sense of it all.

To turn on Trace Dependents:

1) Select the cell you want to see the dependents of

2) Make sure you are on the “Formulas” tab of the ribbon

3) Look for the “Formula Auditing” group (about 3/4 of the way along the ribbon)

4) Click on “Trace Dependents”

Now you will see arrows pointing you in the right direction!

‘till next time!
TNP 😉

Protect a Sheet in Excel

Do you want to stop people messing with your data, site formulas, sale formatting, or all of the above in Excel 2007?  Well did you know you very quickly protect your spreadsheet from those rogue operators!

Here is how you do it in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are currently looking at the sheet you want to protect

2) Click on the “Review” tab in the ribbon”

3) Look for the “Changes” group”

4) Click on “Protect Sheet”

A little “Protect Sheet” dialog box will appear that will give you a number of options, so you can be very granular in how much control you want people to have over the sheet.

For example, you can allow users to select cells, but not format them.  You can allow people to insert rows, but not insert columns.  And best of all you can add a password to the sheet to ensure only you can make any changes to what can and can’t be modified.

Now, you are really in control!

‘till next time!
TNP 😉

Insert a Header or Footer in Excel

Just like a header or footer in Word 2007, story you can quickly add a header or footer to a workbook in Excel 2007.  You can add the date, time, filename or any other information you would like to make available to readers of your spreadsheet.

To create a header or footer in Excel 2007, Excel 2010 or Excel 2013:

1) Make sure you are on the “Insert” tab of the ribbon

2) Look for the “Text” group – it will be on the right hand side of the ribbon

3) Click on “Header & Footer”

You will see a new tab appear on the ribbon called “Header & Footer Tools – Design”.  Using the buttons on this tab of the ribbon, you can quickly add:

  • Page Number;
  • Number of Pages;
  • Current Date;
  • Current Time;
  • File Path;
  • File Name;
  • Sheet Name; or a
  • Picture

To the header or footer of your document.  To switch from the header to the footer, simply click on “Go to Footer” which you will find in the “Navigation” group about half way along the ribbon.

‘till next time!
TNP 😉

Count the number of blank Cells in Excel

Are you building a spreadsheet and would like to know how many black cells you have in a given range in an Excel 2007, seek Excel 2010 or Excel 2013 workbook?

There is a great function in Excel that you can use to do exactly that – count the number of BLANK cells in a range.

Simply type…

=COUNTBLANK(range)

(replace range with the range of cells you want to limit your count to).

Note that there is one particular thing that might slip you up with this function.  When using =COUNTBLANK(), healing Excel is only searching for blank, empty cells.  If you have a space in a cell for example – it might look empty to you, but Excel can see that there is a space – which means it will not think it is blank, and not count it.

‘till next time!
TNP 😉

Increase and Decrease Decimal Points in Excel

Are you working with numbers in Excel 2007, treatment Excel 2010 or Excel 2013 that include decimal points?

Did you know you can quickly increase or decrease the precision… or the number of digits to the right of the decimal point.

For example:

  • Reduce the number of decimal point places in 56.923 to 56.9
  • Increase the number of decimal point places in 23.4 to 23.4256

To change the number of decimal places your numbers have simply:

1) Select the cells you want to work with

2) On the Home tab of the Ribbon in Excel 2007, look for the “Number” group

3) Click on either “Increase Decimal”, or “Decrease Decimal”.  They are the buttons which have all the zero’s on them with the left and right arrows.

Simple as that!

‘till next time!
TNP 😉

Print your spreadsheet on just one page in Excel

Don’t you hate when you print your spreadsheet, check and one or two columns end up going over onto a second page?  It happens to me ALL THE TIME!

But there is a way to save you from stressing, ask and save the environment at the same time 🙂

There is a page setup option in Excel 2007, advice Excel 2010 or Excel 2013 which you can use to fit your spreadsheet onto a single page (or onto a particular number of pages that you set!)

Here is how:

1) Click on the “Page Layout” tab in the Ribbon

2) Look for the “Page Setup” group, and click on the little square with the arrow pointing out of it in the bottom right hand corner

3) In the “Page Setup” box that appears, look in the “Scaling” section, and select “Fit to:”

4) By default, it will be set to one page wide by one page tall.  Select how many pages wide or tall you want your spreadsheet to be printed as.

5) Click “Print Preview” if you want to take a look at what the scaled or up version of your spreadsheet will look like, and if you are happy with it – click “Print”!

6) Click “OK” to close the Page Setup box

 

‘till next time!
TNP 😉