How to use the Layout tab in MobiSheets

Once you’ve finished the first parts of your Spreadsheet work, you’ll need to tweak the layout to make it easier to read, or to prepare it for printing or PDF conversion.

Here's how to do it 

1. Open your Spreadsheet.

2. Select Edit at the bottom of your screen.

3. Tap the Home button found at the top.

4. Select Layout from the dropdown menu.

5. You'll then be given the following options:

Margins

• Normal Margins
• Wide Margins
• Narrow Margins
• Custom
• Horizontally - Center the content(data/table) horizontally on the page
• Vertically - Center the content(date/table) vertically on the page

Note: Both the ‘Vertically’ and ‘Horizontally’’ options can be selected at the same time.

Orientation

• Portrait
• Landscape

Size

• Page Width
• Page Height
• All available page sizes that offered in MobiOffice for Windows and iOS

Scaling  

• Fit
  • • Automatic (No Fit)
      Fit Sheet on One Page - By scaling the worksheet for printing, the user can make his data fit to one page.
    • Fit All Columns on One Page - It is very common for printed Excel spreadsheets to have a column or two of data that spills over onto extra pages. This option offers a way to fit all of the columns on one page.
    • Fit All Rows on One Page - This option offers a way to fit all of the rows on one page.
    • Fit Sheet on - Pages Width - Pages Height
• Scale  - From a minimum of 10% through to 400%
• Adjust to 100%
• Right to left sheet - same functionality as in Windows and iOS, i.e. outlook of the sheet is shifted to right to left

All settings above refer to the current sheet. You can apply different properties to each sheet.

All of the above can also be accessed from the 'File' selection in the main dropdown

1. Click Home again and navigate to File.

2. Select Print.

3. Select Print Settings found at the top of your screen.

 4. Choose your preferred options that appear at the bottom of your screen. Tap Print once you are ready.

We hope this article has provided you with valuable insights on how to effectively use the Layout tab in MobiSheets. Mastering these options allows you to create well-structured and visually appealing spreadsheets, enhancing both your workflow and productivity.