![]() Therefore, creating custom views could be a much quicker approach. You could write some macros that would hide columns/rows based on certain criteria (shameless plug: check out the VBA Starter Kit section for an example of this), but this could be unnecessarily complex in a real-world example. It would likely be beneficial to allow the user to quickly switch between views of quarters only, no quarters, all detail, USA detail only, etc. There is a lot of detail here that may or may not be necessary depending on the audience. The example file looks like this to begin: To get started, I’ll be working with a short month over month income statement that has subtotals by quarter. Using Excel custom views can make this process smoother and can provide some nice interactivity to viewers of your report. However, have you ever found yourself creating multiple views of the same report depending on the audience? Often, this requires a separate tab which is more work for you as an analyst, not to mention it increases the size of the file and resources required to update. It’s probably something you do on a regular basis. ![]() Howdee! The ability to hide columns in Excel (or rows) is not a topic that’s ground-breaking news by any means.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |