Expand Images

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Scripts')
    .addItem('Expand Image', 'expandImage')
    .addItem('Contract Image', 'contractImage')
    .addToUi()
}

function expandImage() {
  const columnWidth = 300
  const rowHeight = 300

  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sh = ss.getActiveSheet()
  var cell = sh.getActiveCell()

  sh.setColumnWidth(1, columnWidth)
  sh.setRowHeight(cell.getRow(), rowHeight)
}

function contractImage() {
  const defaultColumnWidth = 100
  const defaultRowHeight = 21

  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var sh = ss.getActiveSheet()
  var cell = sh.getActiveCell()

  sh.setColumnWidth(1, defaultColumnWidth)
  sh.setRowHeight(cell.getRow(), defaultRowHeight)
}