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.
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.