Question description:
This user has given permission to use the problem statement for this
blog.
I have a Problem with a formula on an excel spreadsheet.
We have a spreadsheet we keep track of items checked in and out of. I have made a formula for one of the cells that is simple "=(cellB-cellD)" I want it to auto-fill the formula as we add rows. I pasted the formula to the collum. That ended up with a ) placed in the Collum all the way down the sheet filling the sheet. Now we cannot insert new rows. we also like to sort out all the rows that have returned all their items but when we do that it takes away all the blank row so we can no longer add new rows to the spreadsheet.
I am sure there is something simple I did wrong could you please help me figure it out.
Solved by A. A. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/12/2017 - 08:12
Hello! Welcome to Got It Pro-Excel.
Excelchat Expert
06/12/2017 - 08:14
Hi there
Excelchat Expert
06/12/2017 - 08:16
We're so glad to support you of your Excel formula today.
Excelchat Expert
06/12/2017 - 08:18
Well, if you have any issue in accessing our chat area, please keep refreshing the browser to come with us
User
06/12/2017 - 08:19
sorry got side track are you still there
Excelchat Expert
06/12/2017 - 08:19
Oh yes, glad to talk with you here
User
06/12/2017 - 08:20
I tried to upload my file but it would not let me
Excelchat Expert
06/12/2017 - 08:20
Is it a big file of yours?
User
06/12/2017 - 08:20
it is 9mb
Excelchat Expert
06/12/2017 - 08:21
oh, you may share it with google spreadsheet then share the link with us
User
06/12/2017 - 08:21
I have it on my google drive can you access it there
Excelchat Expert
06/12/2017 - 08:21
Upload at your google drive then share the link with us
Excelchat Expert
06/12/2017 - 08:22
Yes, please make a shared link that can be edited by us
User
06/12/2017 - 08:22
I am new to google drive and you walk me through that
Excelchat Expert
06/12/2017 - 08:22
Sure :)
User
06/12/2017 - 08:23
sorry I am so helpless
Excelchat Expert
06/12/2017 - 08:23
no worries
User
06/12/2017 - 08:23
https://drive.google.com/open?id=1wIRoalqWzrFOCO6bu9Qu0pOTELQ1kiK2
Excelchat Expert
06/12/2017 - 08:23
Open your spreadsheet file at the google
User
06/12/2017 - 08:23
is this it
Excelchat Expert
06/12/2017 - 08:24
Yeah, you made it. I'm opening it now
User
06/12/2017 - 08:24
I got luck with a right clik
Excelchat Expert
06/12/2017 - 08:24
hahha
Excelchat Expert
06/12/2017 - 08:24
everyone is lucky enough
Excelchat Expert
06/12/2017 - 08:25
It really seems a big data,
Excelchat Expert
06/12/2017 - 08:25
takes time to open
User
06/12/2017 - 08:25
its all the empty blamk rows
Excelchat Expert
06/12/2017 - 08:26
alright, opened the file now
Excelchat Expert
06/12/2017 - 08:26
May I know the sheet we're working on here?
User
06/12/2017 - 08:27
check out sheet
Excelchat Expert
06/12/2017 - 08:27
okay
Excelchat Expert
06/12/2017 - 08:28
seems looks good
Excelchat Expert
06/12/2017 - 08:28
which column should be corrected?
User
06/12/2017 - 08:28
column G
Excelchat Expert
06/12/2017 - 08:29
Your column G is locked, it means cannot be edited
Excelchat Expert
06/12/2017 - 08:29
It's only viewing
User
06/12/2017 - 08:29
no password to unlock
Excelchat Expert
06/12/2017 - 08:29
okay
User
06/12/2017 - 08:31
we have volunteers entering data and I tried to lock cell so they would not type over the formula
Excelchat Expert
06/12/2017 - 08:31
okay got it
Excelchat Expert
06/12/2017 - 08:31
already unlocked
Excelchat Expert
06/12/2017 - 08:32
Which location does we get in trouble starts at column G?
Excelchat Expert
06/12/2017 - 08:32
Is it at G6105?
Excelchat Expert
06/12/2017 - 08:37
Hello
Excelchat Expert
06/12/2017 - 08:37
I'm working on your data now
Excelchat Expert
06/12/2017 - 08:38
Please bear with me, I will send the file very soon while in session
Excelchat Expert
06/12/2017 - 09:02
I'm about to send the file with you, takes time really to upload
Excelchat Expert
06/12/2017 - 09:02
through google sheet
Excelchat Expert
06/12/2017 - 09:03
Well, to brief you for what I have done on the file
Excelchat Expert
06/12/2017 - 09:03
Right click at the check out sheet, then click "View code"
Excelchat Expert
06/12/2017 - 09:04
A window for visual basic will be pop out
Excelchat Expert
06/12/2017 - 09:05
Then type this at the window
Excelchat Expert
06/12/2017 - 09:05
ActiveSheet.UsedRange
Excelchat Expert
06/12/2017 - 09:05
then press enter
Excelchat Expert
06/12/2017 - 09:05
Click "File" menu then "close" to save and go back to the worksheet
Excelchat Expert
06/12/2017 - 09:06
Try adding rows now
Excelchat Expert
06/12/2017 - 09:06
Try this procedure while on the go
Excelchat Expert
06/12/2017 - 09:06
almost 4 minutes more to upload the file at google drive
Excelchat Expert
06/12/2017 - 09:10
https://drive.google.com/file/d/1zLTOLbEi5IhJ46khVDjZ_zY9-0RPZwmb/view?usp=sharing
Excelchat Expert
06/12/2017 - 09:11
Please check on this file, hopefully the procedure works for you and let me know
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
