Expand Columns Release For Free

How to Fit Column Width in SAP Business One Open any menu or report that has SAP grid. Click on ?View???Fit Column Width? The columns will be resize and fitted automatically.

To change the layout, choose Change Layout or Settings ? Layout ? Change. The Change Layout dialog box shows you which columns are currently displayed and which additional columns can be displayed.

To change the width of the key figure columns, proceed as follows: From the initial or drilldown list, select Settings Column width Key figures . Enter the number of characters you require for the column width in the Column width field and pressENTER .

Change the column width to automatically fit the contents (AutoFit) Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width.

Tips & Tricks: 3 ways to resize the columns in most windows in SAP Business One Fast. Double click on the divide between the column headers to resize to optimum width based on the column content ? or drag to resize to personalised width. Faster.Fastest.

Left-click the mouse button in the header between the columns or rows that you selected and drag the mouse to the left and right for columns and up and down for the rows to adjust the size of all of the selected columns at once. That's it.

Outline Levels Clicking the Number 1 box will collapse all of the groups. Clicking it again will expand the groups at the first level. If you have groups within groups then you will see additional numbered levels. Clicking each number will allow you to expand and collapse the data to the level you want.

Resize columns Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.

Select the rows you want to ungroup. Go to the Data tab > Outline group, and click the Ungroup button. Or press Shift + Alt + Left Arrow which is the Ungroup shortcut in Excel.

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now column A should be unhidden in your Excel spreadsheet.