Skip to main content

How to Open Two Excel Files Side by Side in Two Monitors?

The best solution is using LibreOffice. With LibreOffice Calc, you can open one Excel spreadsheet in one monitor and another speadsheet in other monitor to compare, view or edit.

Change the configuration in Excel 2007 or 2010 is another solution by check the check box 'Ignore other application that use Dynamic Data Exchange'. You may encounter with the run-time error when you attempt to close or open again.

References:

Comments

Popular posts from this blog

Visual Studio 2010 Keyboard Shortcuts

These keyboard shortcuts are helpful. Some of them are not document in Visual Studio 2010 Express, for example: <Ctrl> F5 to run the application without debug <Ctrl> Period or <Ctrl> Space for code completion. <Ctr> <Shift> <B> to build the solution For more download the Visual Studio 2010 Keybinding Posters from Microsoft. Credit:  Visual Studio 2010 Keyboard Shortcuts - ScottGu's Blog DevCurry: 30 Favorite Visual Studio Keyboard Shortcuts

SQL Questions and Answers - Part 3

What is a view? A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. ( msdn.microsoft.com ) What is an Index? A Microsoft® SQL Server™ index is a structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure that allows SQL Server to find the row or rows associated with the key values quickly and efficiently. ( msdn.microsoft.com ) What are all the different types of indexes? These are different types of indexes in Microsoft SQL Server 2008R2: Clustered : A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemente

Recent Activity

It’s fun to check my email account recent activity. Here is the fun. Someone attempted to log in to my account from other countries. It is good to check activity log in your Gmail, Hotmail, Yahoo, Facebook, and other accounts frequently.