There are currently no comments for this tip. Be the first to leave your comment—just use the simple form above! This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. View the most recent newsletter. Toggle navigation. Subtotals Option Grayed Out. Author Bio. Using a Cell Value as a Worksheet Name in a Formula Excel allows you to easily develop formulas that pull values from worksheets and workbooks other than the one in which Discover More.
Clearing the Contents of a Table Want to get rid of information within a table, but not the table itself? Automatic Text in an E-mail When creating an e-mail address hyperlink using the Insert Hyperlink dialog box, Excel allows you to enter a subject for More ExcelTips menu. The file he was working with is a file I created with a Microsoft Query enabled to refresh on open in the background. He runs that file and copies the data out and into another file so he can edit it. I did some research and found that the queried data is still in some kind of list or range.
Click that and you should be ok. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account.
You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. October 31, Similar Threads Subtotalling 1 Oct 14, Import external data into Excel so I can subtotal it 2 Jan 28, Subtotal function not available 3 Jun 20, subtotal function won't work 1 Apr 8, Sub Totals option greyed out 1 Oct 30, automatic subtotal 1 Jun 20, Subtotal out of sequence 1 Sep 1, Subtotal 3 Dec 11, Oct 14, Import external data into Excel so I can subtotal it.
Jan 28, Subtotal function not available. Jun 20, Apr 8, Sub Totals option greyed out. Oct 30, Subtotal out of sequence. Sep 1, Dec 11, Select the options as given above. Select OK. The data given below will be displayed. Subscribe via Email.
0コメント