Layouts are different configurations of a budget or forecast worksheet. A layout can include dimension filters, search results and/or the status of the workflow column (whether it is expanded, collapsed or partially expanded).
You can configure and save multiple layouts for each worksheet, to get different views of the same budget or forecast. The ability for each user to save their own layouts removes the need for budget owners and administrators to create multiple workbooks to satisfy the needs of different audiences. Each budget or forecast user can customize the worksheet layout to view the information they need more quicklyYou can share your layouts with other users to apply when they open the worksheet.
For example, suppose your business operates in three countries (Australia, the USA and the UK) and you have one budget workbook with data for all three countries. You can apply a filter to view the budget for Australia only and save that view as a layout. You can then repeat that step to save layouts for each of the other two countries, to create four layouts in total; the original consolidated budget and one for each country.
Save a layout
Set up (configure) the worksheet in a particular way. For example, you might want to apply a filter, search for a specific item and/or expand the workflow column.
Click Layout None > Save as new custom layout… above the grid.
Enter a name for the layout.
Determine who can use the layout. Learn more about sharing layouts in the next section.
Click Save.
Share a layout
You can share a layout with one or more other users when you first save a layout or later, via the layout’s Share button. You have three sharing options:
Only me - Do not share your layout with anyone; keep it for your personal use only.
Everyone - Share your layout with all users who have access to the worksheet.
Selected users - Share your layout with a subset of the users who have access to the worksheet. When you select this option, you can select one or more users from the list that displays.
| Info |
|---|
When you share a layout with a user, the user will only have access to the layout |
after they have been assigned a row in the worksheet’s workflow. |
In the following example, the budget administrator created four layouts for a worksheet and only shared one of them with Bill Branchmanager. He assigned Bill some rows in the worksheet. When Bill opens the worksheet, he sees the shared layout in his Layouts menu. He can apply that shared layout but cannot edit or delete it. He can also create his own layouts.
Apply a layout
The Layouts menu displays a list of all the layouts you saved and any that have been shared with you. You can switch between different layouts to automatically quickly change your view of the worksheet.
Click the Layouts menu and select the layout you want to apply.
Edit a layout
When you apply a layout, if you then change the worksheet configuration, the layout is different. You have the option to revert to the original layout, update the original layout with the changes or create a new layout (and leave the original intact). You can also use the edit function before you make changes, then your layout are automatically updated.
To undo your changes and revert to the original layout, click Layouts > Revert to [layout name]. The grid updates and reapplies your original layout.
To save your changes and update the original layout, click Layouts > Save Changes to [layout name]. The grid remains in the updated layout.
To save a new layout and leave the original as it was, click Layouts > Save as New Layout, then enter a name for the layout and click Save. The grid remains in the new layout and that layout is added to the list of layouts.
Delete a layout
If a layout is no longer useful, you can delete it. When you delete a layout it is removed from the list of layouts, so it is You can edit the name, sharing settings and configuration of any layouts that you create. Your changes flow through to any users you have shared the layout with. You cannot edit a layout that has been shared with you. All of the editing options are available in the Layouts menu.
To edit the layout’s name or sharing settings, click its Share button, make your changes, then click Save.
To intentionally edit the layout’s configuration, click the Edit button before the layout name, make your changes, then click the Save button that displays after the layout name.
If you unintentionally make a change to a layout’s configuration, you can either save your changes as a new custom layout (and leave the original intact) or revert to the default layout (discard all changes).
Delete a layout
When you delete one of your layouts, it is instantly removed from the list of layouts and no longer available for other users to apply (if it had been shared).
Apply the layout you want to deleteClick the Layouts menu, then click Layouts > Delete Layout > Deletethe Delete button next to the layout.
On this page
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|