Category Archives: Excel
Tip #219_Excel
Excel: Hiding Everything But Your Working Area
If you want to keep people away from areas of your worksheet and just focus on a specific area – or you want to just keep a spreadsheet looking tidier – you can hide all rows and columns outside your designated area.
Read MoreTip #213_Excel
Excel: Show Me the Values
Did you know that if you select part of a formula (up in the formulas bar) and press the [F9] key – the actual value of that cell (instead of just it’s address) will appear.
Read MoreTip #212_Excel
Excel: Fun with Links
If you have a very large spreadsheet – consider adding HYPERLINKS to help you and others move around the spreadsheet must faster.
Read MoreTip #198_Excel
Excel (Intermediate): Some Nifty SUBTOTAL feature tricks
This is a play-along tip – if you want to try out the tips below…open the FREEZING.XLSX file located at www.ctccomputertraining.com/students – and click the EXCEL button – then click the FREEZING.XLSX link under the EXCEL – LEVEL 2 heading.
Read MoreTip #196_Excel
Tip #192_Excel
Tip #190_Excel
Excel: Are you a wiggler?
Paste as Values is a handy function, if you need to convert some equation results into constant numbers. But it is a Paste Special function – which requires an addition step (after you COPY, you need to either right-click (or reach up and click the bottom-half of the PASTE button) and figure out which of the Paste icons is the VALUES icon).
Read MoreTip #188_Excel
Excel (Advanced): vLookup to Return a Function Result
Those familiar with VLookup know that they are a handy way to look for one value (or name) and return the corresponding value in a table. But what if you want the result of a function – instead of the lookup value?
Read More