Open workbooks in different windows: All Listings RSS

Filter listings...
https://social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45-806f-9a42258bdb5f/how-to-open-two-excel-files-in-multiple-monitors-in-windows-7?forum=excel

social.technet.microsoft.com/Forums/en-US/6ba32569-19a0-4b45...

How to open two excel files in two excel windows using multiple monitors in Windows 7.
Currently it opens multiple files on top of each other on the same one monitor.

Visited115
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/i-want-to-open-2-excel-files-in-separate-windows/f7588d9a-3c41-466f-8f01-3b6ab9661ae3

answers.microsoft.com/en-us/office/forum/office_2010-excel/i...

I want to open 2 excel files in separate windows to view them side by side... but each time I try, it opens them in the same window.

Visited206
http://stackoverflow.com/questions/20986436/hiding-rows-in-excel-based-on-words-in-a-cell

stackoverflow.com/questions/20986436/hiding-rows-in-excel-ba...

I am VERY new at VBA and have been searching for VBA code that can do what I want. I have tried several and attempted to adapt them however I just can't seem to get them right so thought I would try for some help!

Visited87
http://stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a-row-or-column-in-excel-without-using-vba

stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a...

I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to kno ...

Visited104
http://www.mrexcel.com/forum/excel-questions/550371-hide-rows-based-formula-result.html

www.mrexcel.com/forum/excel-questions/550371-hide-rows-based...

I dont know much about VBA but can anyone help? I need a macro that will hide all rows where the formula result is zero as a result of the cost centre selected from a validation list?

Visited73
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/automatically-hide-rows-in-excel-based-on-value/17036d97-a5c9-42a2-9f2d-f53d53510da7

answers.microsoft.com/en-us/office/forum/office_2010-excel/a...

I have to develop an excelsheet where a row is hidden automatically if the value in cell e is 1 and unhide the row automatically if the value in cell e is 2. And this has to work for all rows.

Visited147
http://excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.html

excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.htm...

This tip contains a macro to hide rows that contain data you don't want to see. (Tips.Net)

 

Visited172
https://social.technet.microsoft.com/Forums/office/en-US/ee76d08d-3306-406d-894c-16fd3cb824d9/each-workbook-in-separate-windows-excel-2010-windows-7?forum=excel

social.technet.microsoft.com/Forums/office/en-US/ee76d08d-33...

A useful thread but my favourite solution is:

  1. Find excel.exe
  2. Create shortcut to excel.exe on desktop
  3. Drag and drop excel files on shortcut
  4. Voila, multiple instance of excel.exe and all file remain visible...

    Visited132