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
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.
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:
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
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!
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.
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 aheader 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:
Number of Pages;
Sheet Name; or a
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.
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.
(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.