How to insert page number Excel
Excel 2000-2003 Go to the start of your Spreadsheet Click \”View\” (menu bar at the top of the page) –> […]
Computers
August 2016
Computers
How to get mixed case in Excel, Microsoft Excel ?
In the cell enter \”=proper(value)\” This will display the value as mixed case e.g \”mr peter conway\” or \”MR PETER
Computers
How to correct circular reference in Excel
Excel correct circular reference Click the Formulas Tab Click Error Checking (small yellow diamond with a Red Exclamation Mark)
Computers
Global Macro workbook Excel 2010
To make a Macro available to all your Excel Spreadsheets save it in the following:- Early Versions of Office Loaded
Computers, Information
Excel Lookup
I am asked this many times, so here is a sample. 1. How can an excel spreadsheet lookup a value
Computers, Information
Excel hashes
Why do the columns in my Excel spreadsheet display hashes? Sometimes when displaying numbers in an Excel spreadsheet the number
Computers, Information
Excel display filetype or all chars after last full stop
Useful formula to display all text after the last full stop =RIGHT(A1, LEN(A1)-(FIND(\”#\”,SUBSTITUTE(A1,\”.\”,\”#\”,LEN(A1)-LEN(SUBSTITUTE(A1,\”.\”,\”\”)))))) How does this work? Let\’s look at
Computers, Information
Excel Change Cell Color on Condition
How to change the color of a cell based on the value of another cell This example changes the color
Computers, Information
Excel 2007 Compatibility How to unhide worksheet
When opening a 2003 version of an Excel Spreadsheet in Excel 2007 I could reference but not unhide a sheet
Computers, Information
Excel 2007 Autofit
PAUL MILLS ASKS Microsoft \”Why the bloody hell did you move it?!!!!!\” Where has Autofit moved to in Office 2007?