TOOLS

How to fix “######” in cells on Kakeibo

If you enter a large number in Kakeibo, the data will be displayed with “######” in the cell. When the column width is not wide enough to display date or value, the data will get covered with “######” in the cell. Here are three ways to display the value entered in a cell when the cell displays “######” in the Kakeibo tool.

1

No.1 : Change font or font size

① Select the cell displayed with “######”.

② In the [Home] tab, select the font or the font size. You can also enter a number directly into the Font Size box and press [Enter] key to set the font size.
③ The value entered in the cell is displayed.

2

No.2 : Shrink to fit and view the whole

① Select the cell displayed with “######”.

② In the [Home] tab, click on the [Alignment] group to open [Format Cells] dialog box.

③ Click on [Shrink to fit] to put checkmark and click on [OK] button.

④ The value entered in the cell is displayed.

3

No.3 : Adjust columns by width buttons

Some of sheets like the annual balance sheet have buttons to adjust the column width. You can adjust the column width by clicking on the [+] and [-] buttons.

Tip

How to display the [Format Cells] dialog box

In the method [No.2 : Shrink to fit and view the whole], I showed you how to display the [Format Cells] dialog box from the Ribbon. Here are two other ways to display the [Format Cells] dialog box.

Display from the shortcut menu

Select a cell and do right-click. A shortcut menu will appear and click [Format Cells…] from the list. In addition to right-clicking, you can also press [Shift] + [F10] to bring up the shortcut menu.

Display with shortcut key [Ctrl] + [1]

Select a cell and press the key [Ctrl] + [1].

Tip

How to change the column width

In kakiebo, you can’t change the column width because the sheets are protected. Normally in Excel, you can change the column width to display the entire number of digits that are displayed as “#######”. Here are three ways to change the column width.

Drag the column

① If you want to change the date column width, point the mouse to the right border of the column A.

② The mouse pointer changes shape. Hold down the left mouse button and move to the right side until you see the date.

③ The column width will be changed.

Double click the column

① If you want to change the column widths of the date and number, Select the column A and the column B and point the mouse to the right border of the selected columns.

② The mouse pointer changes shape and double-click on it.

③ The column widths will be adjusted to fit the data.

Specify a number of the column width

① If you want to change the date column width, select the column A and right-click. Click [Column Width] from the shortcut menu.

② The [Column Width] dialog box will appear. Enter a number of the column width in the textbox and click [OK].

③ The column width will be changed.

The following link is the detail of Excel based personal budget Kakeibo 2020 and Kakeibo Light 2020!

Enjoy Saving money by imagining what you want to achieve!Prev

Learn how to use WoEmail, an email composing and sending Excel toolNext

ARCHIVES

  1. MS WORD

    How to format a date to uppercase month …
  2. MS WORD

    [ Mail Merge in Microsoft Word ] Print o…
  3. TOOLS

    Three solutions to try when you cannot s…
  4. TOOLS

    Learn how to use WoEmail, an email compo…
  5. TOOLS

    Display monthly and annual income and ex…
PAGE TOP