How to stop Number copying time in cell above?

P

Pauliom

New Member
Joined
Dec 30, 2010
Messages
23
I have a time row and below that a number count row.
If the time row had 12.30 on it and I wanted to place a number one below that (in another cell), it just copies 12.30 from the cell above instead of the 1

How do I prevent that from happening?
I use Linux openoffice.org spreadsheet on Linux
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Sorry, but your request just doesn't make sense. Can you try to explain further?
 
Upvote 0
Hi, thanks for replying

In cell G7, I have the time wrote down as 12.30 and in the same column, but further down in G9, when I write the figure 1, it automatically writes 12.30 instead.
 
Upvote 0
So, you just want to switch off Autocomplete?
Turn off automatic completion of cell values
If you don't want Excel to automatically complete cell values, you can turn off this feature.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click Advanced, and then under Editing options, clear or select the Enable AutoComplete for cell values check box to turn automatic completion of cell values on or off.
Click to expand...
 
Upvote 0
Thanks Glenn,
It wasn't quite the same with Linux, but with your help, I found it through Tools, Cell contents and then Autoinput
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
VBA Search a range for a value, then copy and paste data only from source to defined cells.
Replies
0
Views
234
Davion615
D
B
  • Question Question
vba to copy selected cells and some cells adjacent to next blank row in different workbook
Replies
4
Views
90
Peter_SSs
Peter_SSs
J
  • Solved
Stop Excel 'wraparound' scrolling
Replies
2
Views
130
Jehannum_2000
J
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
467
sijpie
sijpie
D
  • Solved
cdate conversion from forms text box submission date errors if blank
Replies
3
Views
61
dmt32
D

Forum statistics

Threads
1,225,543
Messages
6,185,537
Members
453,301
Latest member
jackcolasu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top