Wednesday May 22, 2013
A hyperlink - the blue text in a web page that links to other web pages and documents - also provides quick and easy access between Excel workbooks.
Similarly, a bookmark can be used to create a link to a specific area in the current worksheet or to different worksheets within the same file.
Both make it easier for users to navigate between areas of related data and both are easy to insert and use in Excel.
To find out just how easy, read this short tutorial on how to Add Hyperlinks and Bookmarks in Excel .
Monday May 20, 2013
Insert a Watermark in Excel
© Ted French
Excel does not include a true watermark feature, but you can approximate a visible watermark by inserting an image file into a header or footer of a worksheet.
In visible watermarking, the information is typically text or a logo which identifies the owner or marks the media in some way.
Since headers and footers are normally displayed on every page of a workbook, this method of watermarking is an easy way to ensure that a logo or other necessary information is present on all pages.
To find out all the details read this short tutorial on how to Insert a Watermark in Excel.
Other Formatting Tutorials
Friday May 17, 2013
There are over 1,000,000 rows and 16,000 plus columns in each Excel worksheet.
Most of the time our data fills very little of the available area and all that extra space can sometimes be a problem.
If less experienced users need to access your worksheet they can end up getting lost in the wide open spaces that sit outside the data area.
Or, you may want to restrict access to certain data outside the work area to keep it safe from accidental changes.
Whatever the reason, you can temporarily limit the number of rows and columns accessible by changing the Scroll Area property of the worksheet.
To find out how to do this read the short tutorial on how to Restrict Scrolling in an Excel Worksheet
Wednesday May 15, 2013
Excel Freeze Panes Tutorial
© Ted French
Freeze panes lets you to lock specific rows and columns so that they will always be visible on screen no matter how far you scroll to the right or down.
Using this feature can prevent constant back and forth scrolling in order to check which column or row of data you are looking at in large worksheets.
To find out the details, read this tutorial on using Excel's Freeze Panes feature