Google-sheets – In Google Sheets, is it possible to resize a spreadsheet while retaining its proportions

google sheets

Currently the only way to resize a full spreadsheet in Google Sheets seems to be using Ctrl+A to select the entire sheet and then dragging from either the last column (for resizing all columns) or from the last row (for resizing all rows). Unfortunately, this method doesn't preserve the current proportions of columns or rows, resizing either all rows or all columns to the same size.

Is there any way to increase the size of a spreadsheet proportionally in Google Sheets – so that a full resize will add a proportional amount of size to each column/row without forgetting their current sizes?

Best Answer

The way to resize proportionally the row height and columns width without forgetting the current sizes is by using Google Apps Script. Specifically use setColumnWidth and setRowHeight to set the new sizes and getColumnWidth and getRowHeigt to get the current sizes. The values could be stored using the Properties Service or an auxiliary sheet.

Related Solutions

Google-sheets – Create a 7 Day Running Total and Running Average

Looks like I gave in too fast.

7 day running total: =Sum(Filter(D2:D8,A2:A8<=A8,A2:A8>A8-7))

Filter returns a range of data, filtered based on multiple (can have more than 2 conditions). In the case I'm returning D2:D8 (my count column) filtered where A2:A8 (my date column) is less than the current date (A8) and greater than the current date - 7 days. Stick this in the 7th cell, and drag the cell out to manipulate the formulae into the following cells.

Then for 7 day running average (assuming the above in F) G8 = F8 / 7 :)

Google-sheets – Creating a function that runs when a Google spreadsheet is opened

This little script will:

create an extra menu item, thus making it accessible throughout the workbook. T
the menu item will set the active range to column E, last row + 1.

See the example I've prepared: Creating a function...Google spreadsheet is opened (edit rights)

function onOpen() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // create menu
  var menu = [{name: "get last row", functionName: "getLastRow"}];

  // add to menu
  ss.addMenu("Rows", menu);  

  // execute function
  getLastRow();  
}

function getLastRow() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActive();

  // get active sheet
  var sh = ss.getActiveSheet();

  // get column F
  var indLastCol = sh.getLastColumn()-1;

  // get last row + 1
  var indRowWithout = sh.getLastRow()+1;

  // set new active range
  sh.setActiveCell('E'+indRowWithout);
}

Best Answer

Related Solutions

Google-sheets – Create a 7 Day Running Total and Running Average

Google-sheets – Creating a function that runs when a Google spreadsheet is opened

Related Topic