Sharing is Helpful

Do you know people who use Excel? Don't you think they could benefit by a free subscription to ExcelTips? Invite your friends, colleagues, and family members to join our growing list of subscribers. For instance, you may be part of a forum or discussion list where many of the members use Excel. Why not let them know about this resource? Simply direct them to this address:

https://excelribbon.tips.net

The sign-up box is at the right side of any page on the site.

—Allen
     

ExcelTips (menu) for 27 February 2021

Worksheet functions
Converting to Octal

If you need to do some work in the base-8 numbering system (octal), you'll love two worksheet functions provided by Excel for this purpose. These functions allow you to convert values to octal and convert them back again.

Read this tip »

 
Online and web
Get Rid of Web Stuff

When you copy information from a Web page and paste it into a worksheet, you can end up with more than you bargained for. Here's how to get rid of the extraneous objects that may end up in the worksheet.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Macros extend Excel
Displaying Messages When Automatic Data Changes

It is possible to develop macros that update the information in your worksheets automatically. In such instances, you may want to be notified if the information in a particular cell is changed. Here's how to do it.

Read this tip »

 
Hyperlinks
Extracting URLs from Hyperlinked Images

When copying information from the Internet to an Excel workbook, you may want to get rid of graphics but keep any hyperlinks associated with those graphics. This can be easily done by using the macro highlighted in this tip.

Read this tip »

ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450