Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23

Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31

Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20

Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758

Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
{"id":2166,"date":"2020-09-04T11:15:03","date_gmt":"2020-09-04T18:15:03","guid":{"rendered":"http:\/\/bonbonsguide.com\/wp\/?p=2166"},"modified":"2024-01-09T07:43:46","modified_gmt":"2024-01-09T14:43:46","slug":"view-two-tabs-at-once-in-excel-one-workbook-side-by-side","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2020\/09\/view-two-tabs-at-once-in-excel-one-workbook-side-by-side\/","title":{"rendered":"View Two Tabs at Once in Excel – One Workbook Side By Side"},"content":{"rendered":"

Did you know that you can view two tabs at once in Excel, <\/strong>side by side for a single Excel workbook\/file?\u00a0 This is especially helpful if you are working with a formula that affects another tab, whether checking for accuracy or troubleshooting.\u00a0 It’s also great if you are running what-if scenarios such as in a sensitivity analysis and you would like to keep an eye on the values in two tabs.<\/p>\n

Adding a second window in Excel<\/a> to see two tabs at once:<\/h3>\n
    \n
  1. On the menu bar, click View.<\/li>\n
  2. Click New Window.<\/li>\n
  3. Position the two windows however you’d like.<\/li>\n
  4. Note that it is still one file, so both windows will update when you make a change.\u00a0 You can save from either window.<\/li>\n<\/ol>\n

    Alternatively, if you love keyboard shortcuts like I do, simply use this combination: ALT + W<\/strong>, then N<\/strong>.<\/p>\n

    \"Open
    View menu for Excel<\/figcaption><\/figure>\n

    Here is an example of how it looks for this sample loan calculator file:<\/p>\n

    \"Open<\/p>\n\n\n

    <\/p>\n\n\n\n

    Simple solutions are the best! I truly hope this helped you out! Please consider bookmarking this site and subscribing. I add new content often! Thanks!<\/p>\n\n\n\n

    Also, check out Dose for Excel (click the image below)!\u00a0 It adds over 100 functions to Excel to increase your productivity and more!\u00a0 Disclosure: this is an affiliate link, so I may earn a small commission if you decide to purchase the add-in.\u00a0 Thanks for supporting my blog!<\/em><\/p>\n\n\n\n\"Dose<\/a>\n\n\n\n

    \n\n\n\n
    <\/div>\n\n\n\n

    If I helped you today, please consider leaving a tip via PayPal to help cover blog costs! Thanks!! <\/b><\/p>

    \n
    \n\n\n\n\n\n\n\n
    \"\"<\/figure>\n<\/div>\n

    <\/p><\/form>\n

    Subscribe for more great content!<\/b>\n<\/p>

    \t\t\t
    \n\t\t\t\n\t\t\t\t\t\t\t\t\t

    \n\t\t\t\t\t\t

    \n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t