How to Auto Highlight Active Cell Row and Column in Google Sheets

Подписаться 9 тыс.

Просмотров 20 тыс.

50% 1

Learn auto highlighting selected cell's row and column in google sheets. This we do by using app script feature of Google Sheets.
Copy the code from below.
function onSelectionChange()
{
var range = SpreadsheetApp.getActiveRange();
var sheet = range.getSheet();
var rows = sheet.getMaxRows();
var columns = sheet.getMaxColumns();
sheet.getRange(1,1,rows,columns).setBackground(null);
sheet.getRange(1,range.getColumn(),rows,range.getNumColumns()).setBackground("yellow");
sheet.getRange(range.getRow(),1,range.getNumRows(),columns).setBackground("yellow");
}

Наука

Опубликовано:

27 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 20

@Countdracula6 Год назад

Thank you for sharing!

@spreadsheet_power Год назад

Wc🙏

@teet-traveleatentertainmenttec 4 месяца назад

Thanks Bro.

@spreadsheet_power 4 месяца назад

Welcome 🙏

@user-mx5ql9wj2x 4 месяца назад

thank you Dear From Pakistan

@spreadsheet_power 4 месяца назад

Welcome

@user-xj5uj6pi5b Год назад

Thank you that was a great video and I've already been able to implement it. Quick question - if my spreadsheet has colour through it, how can I implement this code so it doesn't set the default colour back to white each click? I tried taking '.setBackground(null)' out, but then the sheet doesn't update on each click, it leaves the cross sections there.

@spreadsheet_power Год назад

Hi, I have not tried this yet, I will let you know if any solution found.

@user-xj5uj6pi5b Год назад

@@spreadsheet_power thanks that would be invaluable! 😊 Might be tricky - I tried asking Bard and no alternate version of script it gave worked (for google sheets specifically)

@rgopryc104 5 месяцев назад

Love this but: Is there a way to do this without disabling fill in colors? Also I really only need it for rows only, not columns. If you could give some assistance there I'd be very happy. Thank you!

@frankieS2727 Месяц назад

I had the same question, so I asked chatGPT: Method 1: Keyboard Shortcut (Manual) This is the quickest way to highlight the row for the selected cell. Here's what you do: 1) Click on the cell you want to highlight the row for. 2) Press and hold the Shift key on your keyboard. 3)While holding Shift, press the Spacebar key. This will highlight the entire row containing the active cell. Method 2: App Script code: function onSelectionChange() { var range = SpreadsheetApp.getActiveRange(); var sheet = range.getSheet(); var rows = sheet.getMaxRows(); var columns = sheet.getMaxColumns(); // Clear any previous formatting sheet.getRange(1, 1, rows, columns).setBackground(null); // Highlight the active cell's row sheet.getRange(range.getRow(), 1, range.getNumRows(), columns).setBackground("yellow"); }

@rgopryc104 Месяц назад

@@frankieS2727 thank you! The first keyboard trick works well and I’ll try the script tonight. Appreciated.