clipboard

Data replication using Ctrl+D

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

Data replication using Ctrl+D Read More »

Keep text only

Have you ever worked on a lengthy Word document, pasting text from other documents / programs, to then find your final document is a mishmash of different styles and formatting?  Well there’s a simple way to avoid this. Here’s how: Paste the text at the appropriate point within your document; A clipboard icon with Paste

Keep text only Read More »

Transpose your data

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

Transpose your data Read More »

Scroll to Top