Normally, Excel uses the A1 cell reference style which uses letters for column headings and numbers for row headings. However, if you notice there are numbers on both the row headings and column headings, that’s the R1C1 cell reference style. No worries. It’s easy to change it back.
To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the “File” tab.
On the backstage screen, click “Options” in the list of items on the left.
On the “Excel Options” dialog box, click “Formulas” in the list of items on the left.
In the “Working with formulas” section, select the “R1C1 reference style” check box so there is NO check mark in the box.
Click “OK” to accept the change and close the “Excel Options” dialog box.
The columns should now have letters in the column headings.
When you change the cell reference style, it’s changed for all the worksheets in the current workbook. If you save the workbook with this change, any other workbooks you open or new ones you create will use the same cell reference style. If you close the workbook after making this change and you haven’t made any other changes, you will NOT be prompted to save your changes.
Notice that the drop-down list to the left of the formula bar shows which cell reference style is being used. It may seem like you can change the cell reference style using this drop-down list, but we discovered that for some reason it doesn’t work.
Internet security suites are big business. Trial versions packed full of features come with most new Windows computers. They typically include powerful two-way firewalls, phishing filters, and cookie-scanning technology. But you don’t really need all these features.
The web browser in Android 4.3 and earlier has many big security problems, and Google won’t be patching it anymore. If you use a device with Android 4.3 Jelly Bean or earlier, you need to take action.
We’ve written about rooting your Android smartphones and tablets before, but why don’t they come rooted? Google argues that rooting is a mistake for security reasons, as it subverts Android’s security model.
Networked, or IP, security cameras are readily available and, with each new generation of products, increasingly sophisticated. Digging through the available options can be overwhelming though; read on as we walk you through the process with a handy security camera shopping checklist.
Think you know the answer? Click through to see if you're right!
OS X has the built-in ability to handle ZIP archives, but for other archive types like RAR, Stuffit, and especially 7-Zip, you’ll need add-on software. Luckily, there’s a free alternative in the App Store you can download that will do the trick just fine.
Highway to hack: why we’re just at the beginning of the auto-hacking era
By default, when you search the web in Windows 10 using the new Search box on the Taskbar or using Cortana, you get results from Bing. However, if you prefer getting your search results from Google, there’s a way to change this behavior.
Apple now supports Windows 10 in Boot Camp. If you have Windows 7 or 8.1 installed on a Mac, you can take advantage of the free upgrade offer and get Windows 10. Just ensure you’ve updated your Apple software first.
If you’re a Linux user, there’s a good chance you’ve installed Linux alongside an existing Windows 7 or 8.1 system in a dual-boot configuration. You can get the free Windows 10 upgrade without damaging your existing Linux system.