Contextures

Contextures News

Get Info With Excel CELL Function

Jan 19, 2016

Floating macro buttons, CELL function, chart labels, and more, in this week's Excel news.

 -  Debra -  ddalgleish @ contextures.com

Get Cell Information

With the CELL function in Excel, you can get information about a specific cell's formatting, contents, and other details. For example, use this formula to see how wide the cell's column is.

=CELL("width",B2)

I sometime use CELL to get the file path and file name for the workbook (after the workbook is saved).

=CELL("filename",B2)

It's an easy function to use, but it doesn't update right away, if the referenced cell's information changes. However, you can press F9, to force a calculation, or it will update automatically, when the worksheet calculates another formula.

You can learn more about the CELL function on my blog, and download a file with a few examples.

Floating Macro Buttons

When you're working on a big spreadsheet, you can spend lots of time travelling up to the top of the sheet, to click the Ribbon commands or macro buttons. To make things easier to reach, you can create a floating form for macro buttons. Set the form to appear automatically when the workbook opens, and move it anywhere on the screen, for easy access to the buttons.

To see how it works, download the floating form for macro buttons sample file from my website.

user form button

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Chart Labels -- Ann K. Emery shows how to place chart labels directly on a line graph. To keep the chart from looking cluttered, you could select just one or two key points, and format those, using this technique. (Level - Basic)

Lottery Simulator -- There was lots of news about the PowerBall lottery recently, and Chris Newman created a PowerBall simulator that lets you gamble, without losing any money. Even if you're not interested in the lottery, you'll learn a few tricks from the sample file setup. (Level - Intermediate)

More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog.

Keeping Warm

Now that winter is here in full force, we're doing our best to keep warm. My granddaughter got this Anna doll for Christmas, and I'm looking after it for a few weeks. Even though the doll is from the Frozen movie, she enjoys sitting in the rocking chair by the fireplace, just like I do! My father-in-law did all the caning on the chair's seat and back.

rocking chair

NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser:

http://www.contextures.com/newsletter/excelnews2016/20160119ctx.html

_____________

See more recommended Excel products.

________________________

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

 

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: June 14, 2017 11:44 PM