How to Open Multiple Windows in Excel, on Multiple Monitors

Standard

 Excel monitors

Recently, a colleague taught me a neat trick in Excel. We’re both huge fans of the program, and we get strangely excited when we acquire new tips and tricks. Normally, the tricks we seek have something to do with complicated formulas or pivot tables. But this time it was something as simple as “How to open multiple windows in Excel, on multiple monitors.”

I’m sure anyone who has used Excel before knows that you can’t open two separate spreadsheets in two separate windows. I find that extremely frustrating because my job often requires me to compare data between different spreadsheets.  As a user with two monitors, I want to be able to compare those files side by side on each of my screens. Are you in the same boat?

Well, I have the answer to our problem. Behold! How to open multiple windows in Excel…

Step 1: Open up your first Excel spreadsheet (in the way that you normally would).

Step 2: Open your start menu and locate the Excel icon.

Step 3: Press and hold the “Alt” key and select the Excel icon with your mouse.

Step 4: BOOM! You now have two separate files open in two separate windows.

Excel

(Note: This process also works with more than two windows.)

You may also like:

Networking Macs & PCs Together

Standard

 windows and mac communicating

Here at Everon we primarily deal with the Windows environment. However, as Macs have become increasingly popular in the business world, we have gone with the tides and have been assisting in the troubleshooting of Macs, as well. At times, however, those two different types of operating systems can conflict with each other. Here’s how to solve that.

I, myself, have an Apple Mac on Mavericks OS and an HP machine on Windows 7 Professional OS. Sometimes I need to send files back and forth between the two, so my best idea was to set up a mapped drive between the two machines.

To do this, I started on my Windows PC and created a folder. Due to issues with security under user profiles, I created the folder on my C:\ drive called “Mac.” Once that was created, I right-clicked on the folder, and went into Properties ->Sharing and shared out the folder.

Mac1I then went into Advanced Sharing ->Permissions and ensured that “Everyone” was set to “Full Control.” When dealing with permissions in a Windows environment, it is always best to use your Security permissions as your more restrictive permissions. Sharing should always be set to allow everyone full control, and then you tighten it down from there. (Maybe I will write a blog post about that later. ;) )

Once that is done, go to the Security tab and set your permissions. For me, since I wasn’t too concerned with the security of this share, I simply allowed “Everyone” to have “Modify” permissions (not “Full Control”). The difference between “Modify” and “Full Control” in a Windows environment, is that “Full Control” allows the user/group the ability to change/edit permissions and take ownership. This could mean that someone can lock you out of your own share. “Modify”allows creation, deletion, editing of files and folders inside that share, but does not allow for modifying any properties of that share.

Mac2Now you can lock down your permissions to just your Mac (however, I am not going into that here). Once you have allowed “Everyone” the “Modify” rights to your share, you are ready to share it out on your Mac.

Go to your Mac, and in the Finder, go to GO ->Connect to Server:

Mac3

I have modified the image to remove my computer name. However the address string you need to type is the following: smb://{computername}/{sharename}. If you hit the + symbol, it will add this location as your favorites, so you don’t have to type it repeatedly.

Once you have that set, hit “Connect.” This will pop up a new window requesting credentials. These are login credentials to your machine, so input your username and password, and hit Connect:

Mac4

 

This maps the share to your Mac, and you are ready to go! As you can see, I have the mapped share set to show up on my Mac desktop, however this isn’t done automatically, as it merely opens the folder.

Mac5To get the share to show up on your desktop, go to Finder ->Preferences, and inside Preferences put a check mark on Connected Servers. That is it!

Mac6For more help with networking your office Macs to your office PCs, call our technicians at Everon at 1-888-244-1748!

 

What is SFC and what does it do?

Standard

 

Hello. Today I am going to take a techie subject, break it down in a nontechnical way, and try to explain it at a level that is understood by many people. There is a built-in command within Windows that is called SFC (System File Checker).  Most times, this will be run if you are getting error messages and popups stating a .dll file is missing or could not be found.

SFC is a scanning tool that runs within the command prompt and is used to scan all the protected systems files. It is usually run from an administrator command prompt and will replace all the corrupted system files with a clean version that is pulled from a safe place on the hard drive. This location is not one that can be accessed normally, as it is a compressed folder located at %WinDir% \System32\dllcache (“%WinDir%” is just a way of saying the operating system folder, such as C:\Windows).

SFC will run through a series of checks (and corrections, if it finds any corruption). During this whole process the command prompt will stay open and then state that it is 100% completed. If there is no action that needs to be taken from the scan, you will get a message that says “Windows Resource Protection did not find any integrity violations.” If it did find violations it will fix them, and then you will get a message saying it was successful. Afterwards, you will want to reboot your computer.

sfc

UEFI Boot Was a New One For Me, What About You?

Standard

 

windows8fastboottime

 

Hello all, and welcome back! Today I am writing another bit of information that I came across recently. I am going to talk about UEFI boot, that was new to Windows 8. As a tech, we are constantly learning, ourselves. With all the new technology coming out all the time, it is really hard keeping up with all the changes. Some of you may already know about UEFI boot, but it was new to me.

UEFI  is “Unified Extensible Firmware Interface,” which provides an interface between an operating system and the BIOS (platform firmware).  It provides extensive recovery options for the operating system even without another operating system. UEFI was created to replace the older BIOS firmware interfaces and has made its way to being the default boot option on all new computers that are being sold.

UEFI has many benefits that are applicable and rather convenient for the people using them. It provides faster boot up times, it provides the ability for “Secure Boot” that helps prevent untrusted applications/codes from starting before the operating system does (malware and viruses for example), the ability to utilize larger hard drives (over 2 TB), and it allows the use of drives with more than 4 partitions.

I am sure that there are more benefits than what I listed but you get the point: it’s pretty great.

As you can tell by this article, I did not go into extreme technical details about UEFI, so if you would like more information about it, please do not hesitate to reach out to a tech here at Everon. We’re available 24/7 at 888-244-1748.

Microsoft Announces Windows 10!

Standard
W10

The new Windows 10 Start Menu, with customizable panel

Windows 10 is on its way for a release before the end of 2015! Microsoft announced earlier this week that they are releasing their latest operating system on all platforms before the end of 2015, which includes Xbox, smartphones, tablets, PCs and laptops.

This is very exciting news, however, the first question anyone who’s following Microsoft might ask is: “What happened to Windows 9?”

Microsoft has been talking about its imminent Windows 9 OS, pretty much ever since the backlash over a missing Start Menu in Windows 8. So why are they abandoning 9? They chose to move forward from 9 to create a unified theme between all platforms. Here is the direct response from Joe Belfiore, Corporate Vice President of Microsoft:

“This product, when you see [it in its], fullness, I think you’ll agree with us that it’s a more appropriate name. That fullness applies to Windows Phone, too, which will see Windows 10 as its next major upgrade. Windows 10 is built for “screens from 4 to 80 inches.”

Terry Myerson, MS Executive Vice President also states:

“Windows 9 name wouldn’t be right, given the new One Microsoft internal strategy. Hence the move to Windows 10.”

This move to Windows 10 is going to be a huge test for Microsoft, as it is increasingly becoming whispered that Windows 8 is considered a failure, along the lines of the Windows Vista OS.

From early previews of this new OS, however, great things have been said. (For anyone who would like to try the early preview of the Windows 10 OS, you can sign up and download the OS for free here: http://go.microsoft.com/fwlink/?LinkId=510225 (64-bit preview).)

From the early preview, Microsoft has stated it is interested in taking the best parts of Windows 7 and Windows 8 to combine into creating the best operating system yet. Going to a unified operating system for all of Microsoft’s platforms will present a nice solution to integration of the various platforms into a small business environment, making the transition from smartphone, to laptop, to tablet a much easier process for even the most basic user.

Here at our Everon office we have downloaded and installed the tech preview for Windows 10. Just from the past few hours of reviewing it we can report that Microsoft has included a ton of features that are going to help technicians troubleshoot the OS quicker and more efficiently. Stay tuned for future blogs on the various features and find out what you can expect from Microsoft, with regard to this OS. If you have any questions about it, feel free to call our technicians at 1-888-244-1748. We are pretty excited about the changes they have made and would be happy to share our excitement with anyone willing to listen. :)