50:50 for selecting the Row 50. You can highlight the labels in the first row if you want (more on this shortly). You can use any of the concepts above, or a mixture of the techniques described, in order to get your desired characters within a string. To do this on the keyboard, use Control + PgDn (Mac: Fn + Control 03-May-2015 To open Go To window use Ctrl + G (G like GoTo) or F5 . One persons definition of empty might differ from the next persons definition, e. 08-Jun-2020 Ctrl-Down -- The shortcut moves the cursor to the last row with data before the first blank row that is encountered; this may be the last row in 17-Aug-2016 2 Answers · select an random area on your sheet and than · click on the [Name Manager] on the Formula tab, · select [New] · type in a random name Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. But once my mouse reaches the upper limit row excel rapidly scrolls the highlight down to row 165, I have no data beyond 125. I intend to fill a form online using data from an excel sheet. Excel To PDF Conversion Results: Example #3. jump-to-a-row-go-to . First Name can be dragged to either the Row or Column label — it just depends on how you want to see the data. Values can be added, subtracted, divided, and multiplied while moving the values from one cell to another. and dragging to copy the worksheet. Use an Entire Column as a Cell Range. , 05-Jun-2015 In both Excel and Google Sheets it is possilbe to do [Ctrl] [Arrow key] to jump to the last filled non-blank row or column in series of This Excel tutorial explains how to create a hyperlink to another cell in Excel 2003 and older versions (with screenshots and step-by-step instructions). There are two formats of the function, which are the Array Format (which is the most basic format), and the Range Format of the function. How to Create Excel Header Row SoftwareKeep. Just follow these steps to do it: Select the rows you wish to hide; Right click and select hide; But, if you don’t want every user to see the same rows, you will need to create one copy for each contributor as well. Another way you can do this is to use the Type a value for Q4 and press Enter. In this example, we've entered "Hyperlink to cell A5". You can also rename the registry key that holds the settiings so it opens as a new excel. 3 day ago Is there a way in Excel to go to a specific row number? For example I need to find an alternate way to not have to scroll but rather can immediately go to row # 3000. Open, write, save, and customize Excel files with the easy to use IronXL C# library. row_num - It is the row number to use in the cell reference. In a nanosecond you will be at the bottom of the data in that column, regardless of whether it's 12,000 rows long! To return to the top of your data, click the edge of the cell. Step 1: Open your Excel spreadsheet. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Ribbon: Click in a cell or select the entire row. VBA Excel Application OnTime after 1 minute activity Intel XDK: Can we set default download location of the files? Htaccess rewrite url (Shorten url) Very simple onclick not working ClassCastException in getGroupView() Android: only one row is visible Resolving Dependancys on Eclipse Plug-in with• Jump-start your budget, task list, accounting, or financial analysis with Excel's modern templates. Finally, head back up to Excel's Menu Bar and choose Format > Row > Hide. Then, click the Find Next or Find All button. But Excel files can be a little bit messier. Click "Finish". if someone enters the character data even by mistake or typo into the 1000th row of excel of the NIN Number column, the SAS will treat it as a character column, and all the numeric operations will fail. Search within r/excel. Count). Jump to a Row in Google Sheets. Drag an Excel Source component that select all values from the Excel Connection Manager which doesn't enable First row has column names. You go into safe mode by putting the the path to the excel. In the area at the bottom of the dialog box, click on the worksheet you want to use as the target of the hyperlink. Finding the last row in Excel is very important especially for creating dynamic data Range, which can be used for setting dynamic Print Area, dynamic Data Validation list, dynamic data source for Pivot Table, etc. Jan 06, 2015 · In such a scenario it will take you to the first row, first column after the freeze panes. Configuring the Activity In the Body of the Activity For each - Enter the name by which to refer to the current row in the iteration. copyrange. Hence we've put together a list of Excel shortcuts for Mac that will help you save time. It allows you go jump to the 4th row, or the 405th row, quickly. Jun 14, 2019 · Launch Microsoft Excel and open the spreadsheet that contains the graph the values of whose X axis you want to change. 4: Jump to the Start or End of a Column Keyboard Shortcut. To see the technique to jump to the next data entry cell in Excel, watch this short video. Function Keys in Excel are a handy and faster way of doing certain tasks by using the keyboard instead of a mouse. (See next entry for keyboard shortcuts for hiding and unhiding rows or columns. Install the IronXL Excel Library from NuGet or the DLL download; Use the WorkBook. Example attached. They allow you to do awesome things with Excel even if you only have a basic understanding of spreadsheets. Sometimes you need to select a large data range. To quickly highlight the current row, the current column or the entire spreadsheet use the following keyboard shortcuts: "Shift" + "Space": Highlights the current row. The grid of cells make the work area orConvert Rows to Columns in Excel - Coupler. एक्सेल में डुप्लीकेट रो को मर्ज कैसे करे? आप अन्य विकल्प भी चुन सकते हैं जैसे कि Count या Average या Max /Min आदि. Normally, we finish editing a row and pressing the Enter key to make an attempt to move to the beginning of next row for data entry in Excel. Solved by adding a column to the Excel Table with the formula: =A1*1 (date in cell A1) which filled down automatically (love Tables) then copy and pasted as values on top of the errant dates. Take a look at the image below. Ctrl + left arrow key traverses through the left of the cell till last filled data or the first column. For the record, I don’t think avoiding use of frozen panes really prevents this problem. Jan 30, 2019 · Jump to Precedent or Dependent Cells in Excel With a Keyboard Shortcut Printing Selected Rows Or Columns On Every Page of an Excel Worksheet Extracting Data From a Cell Usings Excel’s Left, Right, and Mid Functions To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell. The first row after the header is used to determine the number of columns, which will go into the index. It's OK if you consider the last nonblank cell in column A. Type in the name of your macro and click "OK" to start the recording. · 2. · Make any of the cells active. g. . If freeze pane is not enabled, this shortcut will go the cell upper left cell in the worksheet (A1). Doing so will select all the data Oct 26, 2021 · Getting started with Excel actions. Cells(myrow, 1) = "X" Then ' ok found an entry to process Select Case Worksheets("Data"). Table rows. 2. Copy values from every 5th row, starting with the 5th row Sep 20, 2019 · If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. To freeze the top row or first column: From the View tab, Windows Group, click the Freeze Panes drop down arrow Nov 20, 2019 · Include summary rows for each of the subsets. To jump from cell A1, and select entire Row 3, select A1. Navigation: double-click on cell borders to jump in that direction (e. 2022-01-23 12:52. Nov 16, 2021 · Its 2 nd row is the A4:C4 row. Right-click and select Delete worksheet from the contextual menu, or click the Delete location button in the Cells group on the Home tab. Provide empty string in "Range" property as you might not know the exact range of the list. In many situations something more subtle is better. This issue is related to calculation dotnet excel excelreader excelwriter formula grid grid-editor reogrid spreadsheet wpf xlsx xlsxreader xlsxwriter topics. I tried using the OleDb way and I find out I can't delete a row using that so I tried using the Interop way still no luck, worse the excel file I used can't be close. Click on the "Freeze Panes" option. Here, rows 1 through 4 and columns A and B are in freeze mode. 3. In this case, the data in the cells to be copied can be added in the template itself. Add a date or a timestamp anywhere. 0. Excel – Shortcut to jump to last non-empty row in range skipping empty rows keyboard shortcuts microsoft excel How can I jump from one cell in a column to the last non-empty cell in that column whereas there are empty cells in between? Nov 06, 2013 · Excel Keyboard Shortcuts NOTE: These key assignments are for standard US-English keyboards. A menu appears. 43 points or 64 Aug 23, 2019 · As with pretty much every Excel feature out there, you can use keyboard shortcuts for tab navigation. xlUp); To delete multiple rows: //Get a set of cells in the rows … Jump to PostSimilar to the steps above, this time select the first row beneath your data. Excel find the last row. The copyrange argument copies specified cells into all other rows while exporting. Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. Apply the same to other sheets, if any. Figure 4. With the bottommost cell selected, press and hold Shift and then press Command + Down Arrow. How to Consolidate Data in Excel from Multiple Worksheets. Select the entire row below the row you want to freeze. Freezing rows and columns is the way to go in such cases. Instead of just pulling in any numeric value Search for the Excel connector and add the Add a row into a table action. Scroll down to the bottom row. Excel Columns to Rows: 3 Easy Ways to Transpose Your Data. Today let's look at a really useful but very straightforward Excel tip. In Excel, you can easily jump from one selected cell to another using the Go To option. Click Options -> Sort Left to Right Excel Shortcuts insert a row: Press Alt-4, it will insert the initial row. You can use any keyboard shortcut you want though. Set the check mark at “Headings”. Range("A" & Rows. Click the row number for the top row in the collection that you want to move. Type the cell address of the row which you want to jump to directly, for example, I will input the A560 into the Name Box to go the row 560, see screenshot: 2. There are multiple ways you can iterate through Excel cells and retrieve their data using the optimized performance of GemBox. New Line in Excel Cell How to Insert or Start a New Line. Copy every 5th row, starting with 5th row. Sincerely, Pankaj Sep 27, 2021 · This will also automatically increase the height of the cell (and the row) to fit the number of lines . Count, "B"). Easily select an entire row or column. Hyperlink formula in excel is used to create a shortcut path to quickly jump to any sheet, website or folder. Repeating this process will move you further down the column to just before the next blank cell. You can also use Excel formulas to accomplish the same result. Include your Excel version and all other relevant information. Note: Ctrl G is the hotkey of Go To. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. It works for *. Right-click and select Insert (figure 1). Hold down the Shift key, and then click on the bottom row number to highlight all of the rows in between. In Excel, the 'Home' key moves the cursor to the first column of the current row, totally ignoring any/all blank cells. So, I wrote up this very simple macro that makes it Except the Name Box, you can also apply the Go To command to solve this task. Enter the data you’d like to shift around from a column to a row (or vice versa). How to find empty cells in Excel with Go to Special. Select is used to select one or more elements of Excel (as can be done by using the mouse) allowing further manipulation of them. This will make the cell an active cell. May 21, 2015 · This is one of the most useful Excel tricks that I’ve ever come across, and I’m really amazed at the simplicity and the effectiveness of this. Comment. sub jumprow () dim ws1 as worksheet dim ws2 as worksheet dim rownum as long set ws1 = sheets ("sheet1") 'change this to the sheet name containing your row number set ws2 = sheets ("sheet2") 'change this to the sheet name you wish to jump to rownum = ws1. Sub InsertNRows () Range ("A2"). All of the arguments can be references to other This is how you can use the go to cell in Excel! You can even use a simpler technique to Excel jump to cell in formula using Trace Dependents and Trace Precedents in Excel. Original Excel file. If you change your mind simply go back to the Properties window and delete the range you If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans! But we humans have another issue and that is we easily get tired of scrolling down especially if the list is so long as if it is emerging from the center of the earth. Jun 26, 2012 · At this point, when you press Enter, Excel will move the cursor to the left-most column in the next row. The data will automatically be filtered to remove rows with "Celtics" as the team: If we attempt to use the SUM() function to sum the points column of the The following tutorials explain how to perform other common operations in Excel: How to Delete Filtered Rows in Excel How to Calculate the SumPandas read_excel Examples. If you want to go to the actual last Jan 20, 2016 · Excel is a great tool for data manipulation. 1. . Openpyxl is a Python module to deal with Excel files without Each cell has specific address in refrence to Row and Column. This can save you a lot of time when entering sequential data in large worksheets and make you more productive. Drag a Script Component connect to the Excel Source, then select one column as Input Column. Ctrl Home. But I want the results to be printed row wise, as in the log values of row2 of file should start from the second line( in the result file) and so on. Ctrl+0: Hides columns. NET. Our goal is to help you work faster in Excel. Popular Keyboard Shortcuts for Excel. Select a cell (e. Using this free web tool, you can compare any Excel / Calc document easily. Two Ways to Move Row to Another Sheet Based on Cell Value in Excel. If reference is omitted, it is assumed to be the reference of the cell in which the ROW function appears. Both Row and Column labels can contain data from your columns (e. of Users dynamically? Reshape in R, rows to vectors Jquery Div Changes Not Affected With in the Script Proper error handling withCompare and find diff in two Excel files easily for free. For example , A1 can have a formula , which 04-Apr-2018 Hi All, I need to copy the 1st 500 rows from a spreadsheet and paste in an ERP application. Excel offers the option to hide rows. But this problem sometimes happens even when I dont have the top row frozen. Forum. vertical scrolling in Excel skips my 2000 rows: jumps to 100. Example of usage: the following R code will write the R built-in data sets - USArrests, mtcars and iris - into theExcel pastes the data into several rows. See the example below. Column A is going to be used forJump To & Select Through Edge Of Region: Ctrl+Shift+Arrow: Columns & Rows: Delete Column(S) Or Row(S) Once Selected: RC-D: Columns & Rows: Extend Selection To A Range Of Columns/Rows: Ctrl+Spacebar (or Shift+Spacebar), then Shift+Arrow until you're at end of range: Columns & Rows: Select A Range Of Columns/Rows (#1)Jump to the top of a column: CTRL + ↑ (PC); Command + ↑ (Mac) Jump to the bottom of a column: Excel Insert Row Shortcut. Answer: To create a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Little box. You are thousands of rows deep into your data set and need to get To move to the last cell on the worksheet, in the bottom-most used row of the When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL An Excel formula is entered in a cell , so that it displays the result of the formula in that cell. e. Microsoft Excel contains many keyboard shortcuts to enhance and simplify your Enter the row of the cell you want to jump to in the "Reference" box. So if you find your app fetching values one by one in a loop or iterating over rows or columns you canHello, Excellers. Count is the number of rows in Excel worksheet (just over one million). getting a table with normalized records (one record corresponds to one row). Step 1: Add the days of the week. You often need such transformation for inserting PivotTables or to create database formats. May 22, 2018 · Top 10 Excel Shortcuts for Large Spreadsheets. Get Help? Retrieve License. Select the new cells along with the data below. For example, type an "x" in a column heading, as a placeholder. The Excel Range Object is an object in Excel VBA that represents a cell, row, column, a selection of cells or a 3 dimensional range. excel rows not visible. There is nothing intuitive about this solution, which works in Excel 2003 and 2007. Apparently, Microsoft programmed in a bit of logic to remember the first column you tabbed out of. Navigate to the Excel file and table where we are going to be adding data. Start translation as usual. To answer your question you can delete a single row this way: Excel. 'A simple test that copies every 7th row from the active sheet to a new sheet. Select Loop End Sub. Insert or delete a row, column or range · 4. Tutorial: Working with Word Automation. One-click select all. Similarly, Ctrl + ↑ for the first row Ctrl + ← for the leftmost cell Ctrl + → for the rightmost What he wants to do, however, is to drag the fill handle and have Excel fill every other row with a value, leaving every other row blank, such as 1, blank, 2, blank, 3, blank, 4, etc. GemBox. Sep 27, 2021 · This will also automatically increase the height of the cell (and the row) to fit the number of lines . If the dates are in a row, we can use one simple formula to get the cell address of today's date in that row. Improve this question. To learn how to use this activity, see: Tutorial: Iterating through Rows in a Table. Here shortcut keys are used three times. Steps with details: Launch the Excel application, go to "File > Open," find and select the worksheet, and open it. 50. No one expects you to memorize all of them, but learning the shortcuts that suits your needs will exponentially improve your productivity. " While hiding data, row numbers turn blue to indicate skipped rows. For instance, in the sheet below, you'd select A29:B33 to enter the next five records Move to first cell in worksheet. Note: It is mandatory to provide a jump argument to all the rows and columns. Function keys provide the same output in all versions of Excel making it easier to recall. It’s actually quite easy to do data pivots in Excel. If you don’t want to jump to a specific cell in a different worksheet, but just want to open the whole thing, you can also use the Go To command to do it. xls file. However, we have picked out . To set up this technique, you will create a named range. Ctrl+' Copies a formula from the cell above. ) I have thousands of rows in Excel. When you switch from Tab to Enter, Excel will jump down one row and back to that column. It works just as well when you need to turn a single row of labelsI am trying to copy Word table into Excel (Office 2003). next value will be A501:D1000; Copy selected rows and Paste them ERP application. EXCEL KEYBOARD SHORTCUTS. I need to import some data from an excel with at least 250 rows, and 7 columns. Ctrl+Shift+" Copies value from cell above. Ctrl+Shift+= Inserts a new column Nov 25, 2021 · 6. To start, take a look at the default values. Let me know if you need screens . Hold down the Shift Key, drag, and select Multiple Rows. We all have seen this even of many websites where a word highlighted in blue fonts consists of a hyperlink that would take us to some other location if we click on it. Feb 01, 2021 · Press the Ctrl key on the keyboard. Use IronXL to Open and Write Excel Files. There is no direct formula or function to get the last filled cell in a row or column but we’ll make use of other functions to get the last filled cell in a row. net MVC ActionResult corrupts the excel file when returning from MemoryStream How to using Backbone. The cell or range of cells for which you want the row number. What about the last row in a table? In the above table, assume the cells A16 and A17 are blank. I want to skip such rows before validation. Rows. Let's do scan through a row or a range and calculate the square of all the items in the range. Click on the View tab, then check the box for Gridlines in the Show group. Click and drag the row number of one of the highlighted cells to move them all to a new location. Select command is useful for jumping to any row in a spreadsheet. End(xlUp). Looking at the community, this library and its associated ones try to become a small and easy to711 results for how to switch columns in excel. , click on right border to jump to the right, like Ctrl+→) Format painter: double-click to be able to paint multiple selections (hit ESC to exit) Window: double-click top border to maximize window or shrink to mid In Excel you need to see if you have the Developer ribbon. The When you use the Goto method, the previous selection (before the Goto method runs) is added to the array of previous selections (for more information, see the PreviousSelections property). This tip shows how to select rows, columns, rectangular, or free form ranges in a few clicks. Spreadsheet supports autofitting column width and row height so that column / row takes just enough space to make content of all itsExcel Details: Excel Jump To Cell Reference. The mappings may be slightly different on non-US-English keyboards. Click the location inside the selected cell where you want to break the line. Answer (1 of 3): The following are the two features in Excel, which will take us to any part of an Excel worksheet. Excel offers the option to hide rows. For this example, we'll name ours 'Calendar 2021'. Naming Rows in your Excel DataFrame. End (xlUp). names, row. This is a comprehensive Python Openpyxl Tutorial to read and write MS Excel files in Python. Use VBA code to make hyperlinks that jump to the first row beginning with specific letters: Description: This example shows how to use VBA code to make hyperlinks that jump to the first row beginning with specific letters: Keywords: VBA, Excel, hyperlink, letter, index: Categories: Office, Miscellany Jul 05, 2021 · Step 1: To select a row in Excel using shortcuts, click on the cell in a row that you want to select. Excel will group your data and Jun 07, 2011 · To get there in Excel 2010, click the File tab, and then select Options in the left pane. Once I deleted the data, it then behaved just the opposite, it jumped from 16 to 31 andRow #9: End With. Or right-click and click on Hide. Select the row. ” However Debraj a regular on the Chandoo forum and fellow Excel Ninja nailed it. The pivot table collection is now available on the worksheet resource. In the just above URL see the last part. Shift + Spacebar Select Row. Selected the Cells icon again from the Home tab. Excel writer engines. Sort:-This option is available in the Data Tab under the Sort & Filter group. Insert new sheets. =ADDRESS (row_num, col_num, ref_type, ref_style, sheet_name)It returns the address for a cell when provided a row and a column number. io Blog To transpose columns to rows with Paste Special but link the resulting table to the source data, follow these guidelines. When working with the newer . Row ' find last nonblank row in If Worksheets("Data"). Go To Special in Excel is an important function for financial modeling spreadsheets. If the active cell is non-empty, Excel will stop on the last non-empty cell below the active cell. Learn how to import and export Excel files, and provide users with an interface to interact with those files, all in pure JavaScript. Fill in cell with data from adjacent cell. Then read the second Cell in Row 2 (Column2) and Input. Select Cells/Rows/Columns with one or two criteria in ExcelExcel has over 1 million rows and more than 10000 columns. Style and formatting. Here are the instructions from the image above on how to assign a keyboard shortcut to a macro. Retrieve the value of a single cell, or a table of data. Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Using interesting properties like offset, one can operate across different cells in Excel. For example, if you type 1, 3, 5 and 7 in four cells and then drag them down, Excel knows that the next in series is 9, 11, and 13 etc. Go to beginning of row. Option Explicit Private Sub Worksheet_Change(ByVal Target As Excel. I want a macro that will identify what variables meet a condition (one or the other) and then copy & paste the entire row of information to another pre-existing sheet. Explained for both . Step 2: While holding the Shift key, press and release the Spacebar on your keyboard, and follow it by releasing the Shift Key. Ctrl + I. Excel shortcut for SUM: Keep the Cursor below or to the left of the columns that you wish to SUM. How to do this using keyboard shortcut similar to Ctrl+G in Microsoft Excel? mariosv July 31, 2021, 1:55am #2. Press F4/Ctrl-Y and Repeat. The question was along the lines of how do I jump directly to a cell with formula? I was all about the “click on Formula - Trace Precedents - then click OK and it jumps to the sheet and cell which the formula references. It contains the data that we wish to display in the excel:Select the row from which you want to start text extraction. ○ Stay in. 15. For example, if you start at the top of a column and then press Ctrl+? you will jump to the last cell in that column before an empty cell. Go to specific row in a worksheet with Go To command1. You just saw how to apply Excel string functions across multiple scenarios. Select but I was hoping to discover whether there is a non-VBA method. arrow_forward_ios . Choose how to paste information. The xlsm files support macros. Delete(Excel. Rows cnt = cnt + 1 Debug. Use Alt+Down to move to the next segment and Ctrl+Alt+End to end the translation. Copy the entire data set by selecting each area, right-clicking, and Example: Excel Spreadsheet Get Rows and Cells in Power Automate. Until recently there was no problem scrolling up and down to check/add content 'down under', towards the end of my workspace. Search for Sep 27, 2021 · This will also automatically increase the height of the cell (and the row) to fit the number of lines . Nov 03, 2016 · The Fill Handle in Excel allows you to automatically fill in a list of data (numbers or text) in a row or column simply by dragging the handle. Upon click, the above formula takes you to A15. For example, from 2 to 50 : Sep 27, 2021 · This will also automatically increase the height of the cell (and the row) to fit the number of lines . i have even tried to copy them one by one to make them. Name (required)Quick video tutorial on how to use excel shortcuts to Jump to Row Beginning in excel, provided by Excel Café: http://excel-cafe. Jan 16, 2015 · =VLOOKUP(95,ROW. Below, you can see that the first formula in B2 points to A4. Go to Home > Insert > Insert Sheet Rows. The default column width is 8. com/excel-shortcuts/Shortcut Excel automatically jump to row based on date. Remove Duplicate Rows with Formula. ARRAY(0,Arry1,Arry2),3,False) returns 7 (this does not need to be array entered). Under the hood, gspread uses Google Sheets API v4. Then, type in the days of a week in the second row of the Excel sheet. Jump to. Creating reports in Excel is a laborious, time-consuming task. Place / Go Left /. The best way is to drag and select X rows or columns (X is two or more) if you want to add X rows or columns above or left. The default is one row to insert into an excel file. If you are working on a worksheet with data in columns and want to rotate it and rearrange those data into rowsJump to Content. Excel Jump To Bottom Row. It is represented in a two-dimensional tabular view. Excel shortcut keys can greatly improve your speed when conducting analysis. Hyperlink to Jump to Current Date in a Row. Excel Boot Camp. This will copy all the visible rows only. Then you need to copying this formula down all other rows to apply this formula. In the Inputs and Outputs tab, add a output column name Column. In such a report, when you can click on the Sheet Name for a given row it will jump immediately to that row in the given sheet, opening an parent rows to reveal the target row. It's very easy to do this manually. Example of Go To Special in Excel. com/excel-shortcuts/Shortcut Sep 27, 2021 · This will also automatically increase the height of the cell (and the row) to fit the number of lines