My Favorite Place

If you've been reading my ramblings here for a few months, you know that I've started making videos about the places I visit. I don't post on a fast schedule, but I do add a new video from time to time. You can find the YouTube channel here:

https://go.tips.net/AWYT

Late this past Thursday I finally got around to adding another video, this one about my favorite place on Earth. (No kidding; it really IS my favorite place.) And, interestingly enough, I started the ExcelTips newsletter while I was living in the area described in the video, all the way back in 1998.

Anyway, if you would like to check out this special place, you can do so by visiting the channel page, noted above, or by using this link:

https://youtu.be/kiFBP3LEsts

Let me know what you think, and I hope you have a great week.

—Allen
     

ExcelTips (menu) for 21 May 2022

Powerful spreadsheets
Reducing the Size of the Save As Dialog Box

Dialog boxes are designed to be limited in scope, so that they cover only a portion of your screen. What if a dialog box fills the entire screen, however? How do you get it back to a more manageable size?

Read this tip »

 
Editing
Forcing Editing to Be Done in a Cell

Excel allows you to edit your cell contents in two places. What if you want to limit where editing occurs, so it can only be done in the cell itself?

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Powerful spreadsheets
Leaving a Cell Value Unchanged If a Condition Is False

Ever want the IF function to only return a value if the condition it is testing is true, and not if the condition is false? This tip explains how this function works and what you can do to only return what you are looking for.

Read this tip »

 
Files
Making Changes in a Group of Workbooks

If you need to change the same data in a large number of workbooks, the task can be daunting. Here are some ideas (and some macros) that can help make the task more manageable.

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