Is there a way to have several small spreadsheets open on a screen at the same time in excel?

jderekh64

New Member
Joined
Mar 18, 2024
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Over the years, Excel has been my "go to" tool for when I need a spreadsheet.
There are a couple of situations where I have to use another spreadsheet software program. This creates another whole layer of complexity I would like to avoid. It occurred to me that just because I haven't figured out a way to get excel to do what I need may not be the case for everyone. So, here is one of the issues: I frequently need to have multiple spreadsheets on the screen at one time each with different kinds of formatting such are varying row heights, column widths, colors, etc. Toggling back and forth between different sheets in one workbook is inadequate. There is a less robust program that will allow me to do this. Can it be done in Excel? FYI: I am aware of the "New Window" feature in the View Menu which allows me to have sheets from the same workbook open in different windows. This is helpful at times but doesn't solve the problem of being able to see them on the same screen at the same time and then print out the document with multiple sheets on one screen. I inserted a screenshot which is basically a wireframe less the data to illustrate what I am trying to do.
 

Attachments

  • Screenshot 2024-03-18 at 1.55.33 PM.png
    Screenshot 2024-03-18 at 1.55.33 PM.png
    53.4 KB · Views: 12

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top