Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. ![]() My whole intention is, when i select any of the item from the filter drop down i should be able to calculate the cost per person. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. Freeze Panes in Excel 2007 I have created different data tables in the same work sheeets and applied the filter on those tables. ![]() NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. As shown in Figure 2, a thin black bar appears. Figure 1: An example of freezing panes on a worksheet. Next, go to the View tab, click on Freeze Panes, and then make a selection from the submenu, such as Freeze Panes. ![]() OPs can (and should) reply to any solutions with: Solution Verified To carry out this task in Excel 2007 and later, as shown in Figure 1, first click on the worksheet position you wish to freeze. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |