Home |
Search |
Today's Posts |
#1
|
|||
|
|||
unable to type in selected row
1. I just finished typing row 110, on row 111 I start typing and it bounces
back to 110. What should I do? 2. How do you command columns or rows to repeat info. |
#2
|
|||
|
|||
Hi Andersenjoy
Not sure about the first one, as I do not know what you typed. What happens if you save, exit and go back in, and then type in Row 111? Use formulae to repeat rows or columns. E.g, if you want to repat a value in a column, then in the row or rows underneath, enter a formula. Say you want to repeat A1 in A2, then in A2 type "=A1" without the quotation marks If you want to repeat the value of cell A1 in Cell B1, do the same in B1 "Andersenjoy" wrote: 1. I just finished typing row 110, on row 111 I start typing and it bounces back to 110. What should I do? 2. How do you command columns or rows to repeat info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I type in 100 a 1 appears, 10000 and 100 appear | Excel Discussion (Misc queries) | |||
How do I change the highlight color of selected menu items? | Excel Discussion (Misc queries) | |||
Unable to Edit Shared Workbook | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |