Borders get messed up when inputting grades

Asked By Jason Gilberts 0 points N/A Posted on - 11/03/2011

We have existing grade sheets with shading and borders. As grades are added, the borders get messed up. When someone copy-pastes from a cell, the border from that cell is copied to the new cell. Can the shades and borders be retained while other users are putting in data? Do I have to set an editable range and protect the rest? How?

• Status: Open
• Question Views: 754
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By ciminod19 0 points N/A #104971

Borders get messed up when inputting grades

 

The solution to your problem in copying the data to another cell without messing the borders should be the following:

First, you need to highlight the data the are needed to be copied.

Second, copy the data to the clipboard by  pressing [Ctrl + C].

Third, right click the cell where you want to place the data.

Fourth, click the option Paste Special. A dialog box will appear.

Fifth, since you are working on a class card, select Formulas and Number Formats to copy all the values and formulas on the cell.

For others please refer to this image.

You do not need to set range to protect it. Just do the set of instructions listed.

 

 

About ciminod19

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/07/2011
• Question Category: MS Excel