Did you know that when you copy data in Excel containing hidden columns or rows, Excel will copy the hidden data too? But what if you don’t want to copy the hidden data? Watch on…

To watch without sound, turn captions on by clicking 'CC' then selecting 'English'.

Share:

Other Tips and Tricks

View all
Word Tip – Navigation Pane

Posted:

The Navigation Pane allows you to quickly jump to headings in your document. It’s also a real time-saver when it comes to rearranging paragraphs of ...
Learn more
Excel Tip – Wrapping Text

Posted:

Formatting text to fit in cells can sometimes be a bit troublesome. In this video we show you two simple ways you can wrap text around to fit in a cel...
Learn more
Word Tip – Numbered Headings

Posted:

Some of you may already be using styles to format your heading text. One really useful modification is to automatically number your headings. Follow t...
Learn more
Excel Tip – Date Series

Posted:

Using Excel’s ‘fill handle’ it’s simple enough to create a sequence of days. But what if you need to create a different date sequence; months,...
Learn more
Word Tip – Small Capitals

Posted:

When applying ‘small caps’ to text, your lower-case letters appear as small capitals. This format is ideal for signage and emphasis, when normal c...
Learn more
PowerPoint Tip – Saving Images

Posted:

PowerPoint provides options to save either entire slides or individual objects within a slide as separate ‘graphic’ files. Once saved from PowerPo...
Learn more
Word Tip – Picture Captions

Posted:

It’s surprisingly simple to use the Word captioning tool in order to add number and caption graphic objects in your documents. You can then generate...
Learn more
Word Tip – Auto Text

Posted:

AutoText is one of Microsoft Word’s many ‘Quick Parts’ features. By using AutoText you can store your own text and graphics against shortcuts an...
Learn more
PowerPoint Tip – Merge Shapes

Posted:

When working with shapes in PowerPoint there may be occasions when you just can’t find the shape you need. If this is the case; you can merge shapes...
Learn more
View all

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)