Best Junk File Cleaner: Troubleshoot:add one to all cells in a column

add one to all cells in a column

I was wondering, how can I add one to all the cells in a certain column.
I know there must be a formula for this but I have no idea how to go about it.
Also how would I make a macro for this function.
I will be using it quite often.
I know how to make
a macro but I specifically need to know what the formula is and if it is any different when I want to make it a macro.

Keys to the Problem add one to all cells in a column

Download Error Fixer for Free Now

Hi,
Put a 1 in a cell and copy it.
Select the range of numbers and right click - paste special - select 'add' - OK and your done.
Delete the 1
If you want a macro you can have one but I think that's quite quick.

If this post answers your question, please mark it as the Answer.
Mike H

Because of this add one to all cells in a column error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error add one to all cells in a column can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve add one to all cells in a column error or repair the corrupted and damaged Windows files, you will need a add one to all cells in a column error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

Start the computer and log in as administrator
Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
On the new confirmation window that appears, click Next
Restart your computer after the restoration has been completed

Recommended Method to Fix the Problem: add one to all cells in a column:

How to Fix add one to all cells in a column with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.