Tag Archives: moving

Excel – 5 Paste tips that will save you HEAPS of time

SharynAvatarBlog120x120Ever wondered what the most used command is in Excel?

I have. In fact a few years back I searched for the answer on Google.  I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Continue reading Excel – 5 Paste tips that will save you HEAPS of time

PowerPoint, Word, Excel – nudging shapes so that they align nicely

SharynAvatarBlog120x120PROBLEM: Have you ever tried to perfectly align a line of check
boxes or shapes?  It’s not easy!

SOLUTION: Take control and easily knock wayward shapes back into line.  Note: check out the tip on nudging – it’s fabulous! Continue reading PowerPoint, Word, Excel – nudging shapes so that they align nicely

Excel – Copying or moving entire worksheets between workbooks

1xI’ve had a number of requests to cover copying entire worksheets between files. The number one problem seems to be when the data is pasted into the new worksheet Excel doesn’t resize the column widths to fit the pasted data. Instead the columns seem to reset themselves back to the default width. Possibly the best way to avoid this happening is to use the Move and Copy command in Excel. Continue reading Excel – Copying or moving entire worksheets between workbooks