Using Wafeq Sheets

Sheets view is a powerful way to make bulk changes to your data.

Learn by watching

Enhance your knowledge through visual instruction by referring to this tutorial video on how to use Wafeq sheet or alternatively, peruse the information provided below:

Using sheet view to work faster

How to select

To select a group of cells, utilize the click-and-drag method.

If you need to select cells that span multiple page scrolls, click once on the initial cell, scroll all the way down to the final cell, hold the Shift button, and subsequently click on the terminating cell.

How to use autofill

To enter repetitive data, you can use the autofill feature. Additionally, copying a row of cells across several rows can be achieved by dragging the lower right corner downward.

In cases where a chosen cell contains a date, Wafeq can automatically increase the date on subsequent rows, providing a useful feature for recording recurring transactions.

How to copy and paste

You can copy and paste values via Ctrl+C and the Ctrl+V buttons. allowing for copying and pasting multiple rows and columns.

How to copy from outside of Wafeq

When transferring values from an Excel spreadsheet to Wafeq, make sure that these data entries already exist in Wafeq.

For instance, if recording an expense for a vendor such as "Supplier 1" confirm that the associated contact information has already been entered into Wafeq."

How to insert and delete rows

To delete multiple rows, highlight the ones you would like to delete, subsequently right-click and click on Delete selected rows.

To insert rows, also use the right-click button, and select either Insert a row above or below the one you’ve selected.

To insert multiple rows, select as many rows as you’d like to insert, right-click, then click on Insert rows. For example, to add three rows, select the three rows and right-click, then click on Insert 3 rows.

How to duplicate rows

You can duplicate rows in most Wafeq sheets by right-clicking and choosing Duplicate.