This is another entry point for sheet views. If other people are working on the file, you can sort or filter, and Excel asks if you want to apply that sort or filter for just you, or everyone. To save it, click Temporary View in the sheet view menu, type the new sheet view name, and then press Enter. Excel automatically names your new view Temporary View to indicate the sheet view isn't saved yet. Select the worksheet where you want the sheet view, then click to View > Sheet View > New.Īpply the sort/filter that you want. However, if you're using Sheet Views in Excel mobile, tablet, or desktop, hiding or displaying rows in a Sheet View will change the Default view of the workbook. This lets you see only the columns and rows you care about in Excel for the web without changing the view for others. Important: While using a Sheet View, you can group, hide, or display columns and rows just at you would normally.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |