From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

File documentation with the Workbook Statistics button

File documentation with the Workbook Statistics button - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

File documentation with the Workbook Statistics button

- [Instructor] If you need to provide documentation 2 regarding the current worksheet or the current workbook, 3 there are two functions. 4 One's called cell, one's called info, 5 and a command called worksheet statistics that you need 6 to be familiar with. 7 In cell C1, I'm about to use the function 8 called cell, equal cell, left parenthesis 9 and look at the options that I have for entering. 10 By the way, you also notice these in column B, 11 starting in B2. 12 I need to know the column width of column A, 13 that's width, the last choice. 14 I can double click to pop this into place. 15 Or if I were typing it, 16 double click with double click, column. 17 I don't need to click the column. 18 I can simply click Cell A1, enter, 19 and the answer I get is 14. 20 If I put the mouse pointer on the boundary between A 21 and B, hold down the left mouse button, 22 you see the width 14. 23 But as I move leftward…

Contents