All solutions ROW Expert Solution – Excel ROW Problems

Excel - ROW Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc