table cell locked

I have a schedule in sheet1 and a schedule in sheet2. I want to "subtract" the table range in sheet2 with the table range in sheet1. Sheet2 is the "skeleton" of the schedule, and the determined values in specific cells. Sheet1 is the "skeleton table", just with cells added afterwards. So i want...

I've been using [@[column name]] as a relative cell reference in my excel sheet. Previously I could fill down the formulas and the results would be based on the values in the same row as the cell wherein the formula was placed. (first scenario) No columns where added in the meanwhile and the...

Hi all, a hopefully simple one for you. I have a report which changes daily. That report is linked to sheet 1 on my spreadsheet. I want to transfer the data from sheet 1 column D to Sheet 2 column B automatically. Once this is done I want to be able to manually type something into column C and...

I want to convert an Excel Table into a range, but the option is grayed out no matter what cell that I click in. Under the table tools, none of the options seem to be available - they are all grayed out as well Columns B-F are hidden and I am unable to unhide them Column Headers A, U and Z are...

I hve spent days trying to figure this out. I used table formatting to create alternate row colors not realizing I was also creating a table. Now I cannot add rows or change out of the table format.I've read tons of posts about this and tried them all. The most common suggestion is to click on a...

I am trying to copy the formula: =SUMIF(Table3[1],TRUE,Table3[Cab]) but as i copy through other cells i need to keep "Table3[1]" the same value vs where i need my Table3[Cab] to change to the next table cell. ive looked around as to how you can lock it(like $a$1) but i haven't come across an...