Google Sheets – How to Freeze Row Height or Prevent Line Breaks

google sheets

My question is very similar to a previous question here, but I don't want the scroll bars.
When I paste a link in a cell it usually breaks the cell in multiple lines, increasing the row height. Even if I try to set the row height to 17 pixels, it keeps the same increased size. I don't need to visualize the whole link, I want only it to be clickable. Is there any solution for this?

One solution I found is to adjust the column width, but it creates a new problem: I don't want a very wide column.

Best Answer

Use the toolbar option to switch off wrapped text:

toolbar icon for wrap text

Related Solutions

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);
}

Google Sheets – How to Calculate Average Screen Resolution Based on Visitors

This is what I came up with.

Screenshot

enter image description here

Explained

Column F expresses the weight of the measurement in the series. Multiplying the height and the width by the fraction, will yield the corresponding fraction. A summation will yield a weighed height and width.

Example

I've created an example file for you: Average Resolution