Services4People

  TOCOL function Applies To Effortlessly highlight, filter, and sort data with Copilot in Excel We're giving you a free trial of Copilot Pro. Activate now Release notes Returns the array in a single column. Syntax =TOCOL(array, [ignore], [scan_by_column]) The TOCOL function syntax has the following arguments: array        The array or reference to return as a column. ignore        Whether to ignore certain types of values. By default, no values are ignored. Specify one of the following: 0        Keep all values (default) 1        Ignore blanks 2        Ignore errors 3        Ignore blanks and errors scan_by_column        Scan the array by column. By default, the array is scanned by row. Scanning determines whether the values are ordered by row or by column. Rem...

  How to use Ctrl + Enter Shortcut keys in Microsoft Excel Method 1 : Using Ctrl + Enter shortcut to enter Same Data in Multiple Cells Step 1 – Select the Range of Cells Select the range of cells in which you want to enter the same data.  Use  “Handle Select” and “Drag and Drop” methods to select the range. Step 2 – Enter the Data After selecting the cell range, enter the data in the first cell of the range. Step 3 – Press Ctrl + Enter keys Press the Ctrl + Enter keys. The data will be printed in all the selected cells. Method 2 : Use the Ctrl + Enter shortcut to stay on the Active Cell Step 1 – Select the Active Cell and Enter the desired formula In Microsoft Excel, an active cell is the cell that is currently selected and ready to be edited or used in a formula. Select the Active cell and enter the desired formula. Step 2 – Press the Ctrl + Enter shortcut keys Press the Ctrl + Enter shortcut keys The output will be displayed and the active cell will remain selected. Whe...