Using cell reference to ‘Excel’

Posted Posted in Excel

Technology not only helps us in a practical sense, but it can also teach us to look at things in a different way.  Let’s take using cell reference within Excel as an example: it’s a very simple formula but this small automation can certainly transform the way you do things. If you work with Excel […]

Five sure-fire ways to jazz up your Excel spreadsheet

Posted Posted in Excel

Sometimes it’s the simplest things that make the biggest impact, and this is definitely the case when it comes to formatting your Excel spreadsheet. Following are five sure-fire ways to jazz up your spreadsheet, with the least amount of effort.  Remember to take into consideration the content of your spreadsheet before trying any of these […]

Data replication using Ctrl+D

Posted Posted in Excel

Copy and paste is a popular way to replicate data, but did you know that Excel has a shortcut which does the same thing but in less time?  The shortcut I’m talking about is Ctrl+D, and it enables you to copy all data and/or formatting located in the cell immediately ABOVE the active cell. Similar […]

Page Layout View

Posted Posted in Excel

Does the nature of an Excel spreadsheet – lots of data, displayed in rows and columns – really necessitate drab looking documents?  Personally, I don’t believe so.  And the good news is that, by working in Page Layout View, making your Excel spreadsheet pop becomes a breeze. Here’s an example.  I recently set up a […]

Transpose your data

Posted Posted in Excel

Have you ever spent time setting up an Excel spreadsheet to then decide it would work better if your data ran horizontally rather than vertically?  What do you do? Well, you could copy each cell individually, moving down the column as you go and pasting the data across your chosen row, but this is really […]