Search this site
Embedded Files
SheetsFormulas.com
  • Home
  • Excel/Sheets Formulas
    • calculate running total in Excel and Google Sheets
    • capitalize every letter in Excel and Google Sheets
    • capitalize only first letter in Excel and Google Sheets
    • change negative number to zero in Excel and Google Sheets
    • change negative to positive numbers in Excel and Google Sheets
    • change positive numbers to negative in Excel and Google Sheets
    • combine date and time in Excel and Google Sheets
    • combine multiple columns into one single column in Excel and Google Sheets
    • combine two or more cell in Excel and Google Sheets
    • combine two or more cell with line break in Excel and Google Sheets
    • combine two or more cells and transpose in Excel and Google Sheets
    • convert 1-12 to month name in Excel and Google Sheets
    • convert acres to hectares in Excel and Google Sheets
    • convert alphabet letter to number in Excel and Google Sheets
    • convert date to month and year in Excel and Google Sheets
    • convert date to text in Excel and Google Sheets
    • convert decimal number to binary in Excel and Google Sheets
    • convert euro to USD in Google Sheets
    • convert hectares to acres in Excel and Google Sheets
    • convert kilograms to pounds in Excel and Google Sheets
    • convert kilograms to stones in Excel and Google Sheets
    • convert letter to number in Excel and Google Sheets
    • convert month name to number in Excel and Google Sheets
    • convert number to alphabet letter in Excel and Google Sheets
    • convert number to roman number in Excel and Google Sheets
    • convert a number with two decimals in Excel and Google Sheets
    • convert numbers of days to year/month/day in Excel and Google Sheets
    • convert pounds to kilograms in Excel and Google Sheets
    • convert roman number to number in Excel and Google Sheets
    • convert seconds to time format in Excel and Google Sheets
    • convert stones to kilograms in Excel and Google Sheets
    • convert number stored as a text to date in Excel and Google Sheets
    • convert time to text in Excel and Google Sheets
    • convert USD to EURO in Google Sheets
    • convert weekday string to number in Excel and Google Sheets
    • count blank cell in Excel and Google Sheets
    • count cell between two values in Excel and Google Sheets
    • count cells greater than in Excel and Google Sheets
    • count cells greater than and equal to in Excel and Google Sheets
    • count cells in the column that have the same first five characters in Excel
    • count cells less than in Excel and Google Sheets
    • count cells less than and equal to in Excel and Google Sheets
    • count cells not equal to in Excel and Google Sheets
    • count cells over 10 characters in Excel and Google Sheets
    • count cells that are not blank in Excel and Google Sheets
    • count cells that begin with a specific text in Excel and Google Sheets
    • count cells that contain a specific text and ignore blank in Excel/Sheets
    • count cells that contain errors in Excel and Google Sheets
    • count cells that contain numbers and ignore blank in Excel and Google Sheet
    • count cells that do not contain numbers and ignore blank in Excel/Sheets
    • count if cells contain a specific text in Excel and Google Sheets
    • count if cells start with specific text in Excel and Google Sheets
    • count if cells end with a specific text in Excel and Google Sheets
    • count number of days between dates in Excel and Google Sheets
    • count number of words in a cell in Excel and Google Sheets
    • count the number of cells that have more than 5 character words in a column
    • count the number of occurrences of a text string in a range in Excel/Sheets
    • count words in a range of cells or columns in Excel and Google Sheets
    • COUNTIF based on multiple criteria in Excel and Google Sheets
    • dynamic current date and time in Excel and Google Sheets
    • dynamic current time in Excel and Google Sheets
    • dynamic today and yesterday date in Excel and Google Sheets
    • extract domain URL from a link in Excel and Google Sheets
    • extract left before first space in Excel and Google Sheets
    • extract the nth word in a text string in Excel and Google Sheets
    • extract right after first space in Excel and Google Sheets
    • extract URL domain root in Excel and Google Sheets
    • flip the first and last name in Excel and Google Sheets
    • get sheet name in Google Sheets
    • get text between colons in Google Sheets
    • get text between comma in Google Sheets
    • get the last non-empty cell in a column in Excel and Google Sheets
    • get the first non-empty cell in a column in Excel and Google Sheets
    • move the first word to end in Excel and Google Sheets
    • remove the negative sign from numbers in Excel and Google Sheets
    • reverse the text strings within cells in Excel and Google Sheets
    • split words by uppercase in Excel and Google Sheets
    • sum by month in Excel and Google Sheets
    • SUMIF cells if contains part of a text string in Excel and Google Sheets
    • sum total sales based on quantity & price in Excel and Google Sheets
    • transpose column to row in Excel and Google Sheets
    • transpose row to column in Excel and Google Sheets
    • transpose row to column and ignore blank in Excel and Google Sheets
    • Extract text between characters (parentheses) in Excel and Google Sheets
    • combine data from multiple google sheets and get tab name
    • TEXT function example in Excel and Google Sheets
    • IF formula and example in Excel and Google Sheets
    • SUMIF formula and example in Excel and Google Sheets
    • SUMIFS formula and example in Excel and Google Sheets
    • COUNTIF formula and example in Excel and Google Sheets
    • CONVERT function example in Excel and Google Sheets
    • Wild cards and regular expressions in Excel and Google Sheets
    • calculate percentage changes for containing negative numbers and zero
    • convert pounds to grams in Excel and Google Sheets
  • Google Data Studio
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
      • Data Blending in Google Data Studio
    • Menu Explained
      • File Menu
      • Editing Menu
      • View Menu
      • Insert Menu
      • Page Menu
      • Arrange Menu
      • Resource Menu
    • Data Studio Book
    • GA4 Metrics and Dimensions Definition
SheetsFormulas.com
  • Home
  • Excel/Sheets Formulas
    • calculate running total in Excel and Google Sheets
    • capitalize every letter in Excel and Google Sheets
    • capitalize only first letter in Excel and Google Sheets
    • change negative number to zero in Excel and Google Sheets
    • change negative to positive numbers in Excel and Google Sheets
    • change positive numbers to negative in Excel and Google Sheets
    • combine date and time in Excel and Google Sheets
    • combine multiple columns into one single column in Excel and Google Sheets
    • combine two or more cell in Excel and Google Sheets
    • combine two or more cell with line break in Excel and Google Sheets
    • combine two or more cells and transpose in Excel and Google Sheets
    • convert 1-12 to month name in Excel and Google Sheets
    • convert acres to hectares in Excel and Google Sheets
    • convert alphabet letter to number in Excel and Google Sheets
    • convert date to month and year in Excel and Google Sheets
    • convert date to text in Excel and Google Sheets
    • convert decimal number to binary in Excel and Google Sheets
    • convert euro to USD in Google Sheets
    • convert hectares to acres in Excel and Google Sheets
    • convert kilograms to pounds in Excel and Google Sheets
    • convert kilograms to stones in Excel and Google Sheets
    • convert letter to number in Excel and Google Sheets
    • convert month name to number in Excel and Google Sheets
    • convert number to alphabet letter in Excel and Google Sheets
    • convert number to roman number in Excel and Google Sheets
    • convert a number with two decimals in Excel and Google Sheets
    • convert numbers of days to year/month/day in Excel and Google Sheets
    • convert pounds to kilograms in Excel and Google Sheets
    • convert roman number to number in Excel and Google Sheets
    • convert seconds to time format in Excel and Google Sheets
    • convert stones to kilograms in Excel and Google Sheets
    • convert number stored as a text to date in Excel and Google Sheets
    • convert time to text in Excel and Google Sheets
    • convert USD to EURO in Google Sheets
    • convert weekday string to number in Excel and Google Sheets
    • count blank cell in Excel and Google Sheets
    • count cell between two values in Excel and Google Sheets
    • count cells greater than in Excel and Google Sheets
    • count cells greater than and equal to in Excel and Google Sheets
    • count cells in the column that have the same first five characters in Excel
    • count cells less than in Excel and Google Sheets
    • count cells less than and equal to in Excel and Google Sheets
    • count cells not equal to in Excel and Google Sheets
    • count cells over 10 characters in Excel and Google Sheets
    • count cells that are not blank in Excel and Google Sheets
    • count cells that begin with a specific text in Excel and Google Sheets
    • count cells that contain a specific text and ignore blank in Excel/Sheets
    • count cells that contain errors in Excel and Google Sheets
    • count cells that contain numbers and ignore blank in Excel and Google Sheet
    • count cells that do not contain numbers and ignore blank in Excel/Sheets
    • count if cells contain a specific text in Excel and Google Sheets
    • count if cells start with specific text in Excel and Google Sheets
    • count if cells end with a specific text in Excel and Google Sheets
    • count number of days between dates in Excel and Google Sheets
    • count number of words in a cell in Excel and Google Sheets
    • count the number of cells that have more than 5 character words in a column
    • count the number of occurrences of a text string in a range in Excel/Sheets
    • count words in a range of cells or columns in Excel and Google Sheets
    • COUNTIF based on multiple criteria in Excel and Google Sheets
    • dynamic current date and time in Excel and Google Sheets
    • dynamic current time in Excel and Google Sheets
    • dynamic today and yesterday date in Excel and Google Sheets
    • extract domain URL from a link in Excel and Google Sheets
    • extract left before first space in Excel and Google Sheets
    • extract the nth word in a text string in Excel and Google Sheets
    • extract right after first space in Excel and Google Sheets
    • extract URL domain root in Excel and Google Sheets
    • flip the first and last name in Excel and Google Sheets
    • get sheet name in Google Sheets
    • get text between colons in Google Sheets
    • get text between comma in Google Sheets
    • get the last non-empty cell in a column in Excel and Google Sheets
    • get the first non-empty cell in a column in Excel and Google Sheets
    • move the first word to end in Excel and Google Sheets
    • remove the negative sign from numbers in Excel and Google Sheets
    • reverse the text strings within cells in Excel and Google Sheets
    • split words by uppercase in Excel and Google Sheets
    • sum by month in Excel and Google Sheets
    • SUMIF cells if contains part of a text string in Excel and Google Sheets
    • sum total sales based on quantity & price in Excel and Google Sheets
    • transpose column to row in Excel and Google Sheets
    • transpose row to column in Excel and Google Sheets
    • transpose row to column and ignore blank in Excel and Google Sheets
    • Extract text between characters (parentheses) in Excel and Google Sheets
    • combine data from multiple google sheets and get tab name
    • TEXT function example in Excel and Google Sheets
    • IF formula and example in Excel and Google Sheets
    • SUMIF formula and example in Excel and Google Sheets
    • SUMIFS formula and example in Excel and Google Sheets
    • COUNTIF formula and example in Excel and Google Sheets
    • CONVERT function example in Excel and Google Sheets
    • Wild cards and regular expressions in Excel and Google Sheets
    • calculate percentage changes for containing negative numbers and zero
    • convert pounds to grams in Excel and Google Sheets
  • Google Data Studio
    • Charts Guide
      • Scorecard in Google Data Studio
      • Pie Chart in Google Data Studio
      • Bullet Chart in Google Data Studio
      • Gauge Chart in Google Data Studio
      • Line Chart in Google Data Studio
      • Column Charts in Google Data Studio
      • Combo Chart in Google Data Studio
      • Table Chart in Google Data Studio
      • Pivot Table in Google Data Studio
      • Area Chart in Google Data Studio
      • Scatter Chart in Google Data Studio
      • Bubble Chart in Google Data Studio
      • Maps in Google Data Studio
      • Treemaps in Google Data Studio
      • Bullet Chart vs Gauge Chart in Google Data Studio
    • Configuration Guide
      • Background and Border in Google Data Studio
      • Missing Data in Google Data Studio
      • Conditional Formatting in Google Data Studio
      • Chart Header in Google Data Studio
      • Legends in Google Data Studio
      • Reference Lines in Google Data Studio
      • Report Settings
      • Share Report
      • Manual Publishing
      • Version History
      • Embed a report
      • Get a link to your report
      • Schedule Email Delivery
      • Download as a PDF
      • Interface, Menu and Features
      • Most Used Terms
      • Keyboard Shortcuts
      • Theme and Layout
      • 10 Reasons You Should Be Using Google Data Studio
      • FAQs
      • Data Blending in Google Data Studio
    • Menu Explained
      • File Menu
      • Editing Menu
      • View Menu
      • Insert Menu
      • Page Menu
      • Arrange Menu
      • Resource Menu
    • Data Studio Book
    • GA4 Metrics and Dimensions Definition
  • More
    • Home
    • Excel/Sheets Formulas
      • calculate running total in Excel and Google Sheets
      • capitalize every letter in Excel and Google Sheets
      • capitalize only first letter in Excel and Google Sheets
      • change negative number to zero in Excel and Google Sheets
      • change negative to positive numbers in Excel and Google Sheets
      • change positive numbers to negative in Excel and Google Sheets
      • combine date and time in Excel and Google Sheets
      • combine multiple columns into one single column in Excel and Google Sheets
      • combine two or more cell in Excel and Google Sheets
      • combine two or more cell with line break in Excel and Google Sheets
      • combine two or more cells and transpose in Excel and Google Sheets
      • convert 1-12 to month name in Excel and Google Sheets
      • convert acres to hectares in Excel and Google Sheets
      • convert alphabet letter to number in Excel and Google Sheets
      • convert date to month and year in Excel and Google Sheets
      • convert date to text in Excel and Google Sheets
      • convert decimal number to binary in Excel and Google Sheets
      • convert euro to USD in Google Sheets
      • convert hectares to acres in Excel and Google Sheets
      • convert kilograms to pounds in Excel and Google Sheets
      • convert kilograms to stones in Excel and Google Sheets
      • convert letter to number in Excel and Google Sheets
      • convert month name to number in Excel and Google Sheets
      • convert number to alphabet letter in Excel and Google Sheets
      • convert number to roman number in Excel and Google Sheets
      • convert a number with two decimals in Excel and Google Sheets
      • convert numbers of days to year/month/day in Excel and Google Sheets
      • convert pounds to kilograms in Excel and Google Sheets
      • convert roman number to number in Excel and Google Sheets
      • convert seconds to time format in Excel and Google Sheets
      • convert stones to kilograms in Excel and Google Sheets
      • convert number stored as a text to date in Excel and Google Sheets
      • convert time to text in Excel and Google Sheets
      • convert USD to EURO in Google Sheets
      • convert weekday string to number in Excel and Google Sheets
      • count blank cell in Excel and Google Sheets
      • count cell between two values in Excel and Google Sheets
      • count cells greater than in Excel and Google Sheets
      • count cells greater than and equal to in Excel and Google Sheets
      • count cells in the column that have the same first five characters in Excel
      • count cells less than in Excel and Google Sheets
      • count cells less than and equal to in Excel and Google Sheets
      • count cells not equal to in Excel and Google Sheets
      • count cells over 10 characters in Excel and Google Sheets
      • count cells that are not blank in Excel and Google Sheets
      • count cells that begin with a specific text in Excel and Google Sheets
      • count cells that contain a specific text and ignore blank in Excel/Sheets
      • count cells that contain errors in Excel and Google Sheets
      • count cells that contain numbers and ignore blank in Excel and Google Sheet
      • count cells that do not contain numbers and ignore blank in Excel/Sheets
      • count if cells contain a specific text in Excel and Google Sheets
      • count if cells start with specific text in Excel and Google Sheets
      • count if cells end with a specific text in Excel and Google Sheets
      • count number of days between dates in Excel and Google Sheets
      • count number of words in a cell in Excel and Google Sheets
      • count the number of cells that have more than 5 character words in a column
      • count the number of occurrences of a text string in a range in Excel/Sheets
      • count words in a range of cells or columns in Excel and Google Sheets
      • COUNTIF based on multiple criteria in Excel and Google Sheets
      • dynamic current date and time in Excel and Google Sheets
      • dynamic current time in Excel and Google Sheets
      • dynamic today and yesterday date in Excel and Google Sheets
      • extract domain URL from a link in Excel and Google Sheets
      • extract left before first space in Excel and Google Sheets
      • extract the nth word in a text string in Excel and Google Sheets
      • extract right after first space in Excel and Google Sheets
      • extract URL domain root in Excel and Google Sheets
      • flip the first and last name in Excel and Google Sheets
      • get sheet name in Google Sheets
      • get text between colons in Google Sheets
      • get text between comma in Google Sheets
      • get the last non-empty cell in a column in Excel and Google Sheets
      • get the first non-empty cell in a column in Excel and Google Sheets
      • move the first word to end in Excel and Google Sheets
      • remove the negative sign from numbers in Excel and Google Sheets
      • reverse the text strings within cells in Excel and Google Sheets
      • split words by uppercase in Excel and Google Sheets
      • sum by month in Excel and Google Sheets
      • SUMIF cells if contains part of a text string in Excel and Google Sheets
      • sum total sales based on quantity & price in Excel and Google Sheets
      • transpose column to row in Excel and Google Sheets
      • transpose row to column in Excel and Google Sheets
      • transpose row to column and ignore blank in Excel and Google Sheets
      • Extract text between characters (parentheses) in Excel and Google Sheets
      • combine data from multiple google sheets and get tab name
      • TEXT function example in Excel and Google Sheets
      • IF formula and example in Excel and Google Sheets
      • SUMIF formula and example in Excel and Google Sheets
      • SUMIFS formula and example in Excel and Google Sheets
      • COUNTIF formula and example in Excel and Google Sheets
      • CONVERT function example in Excel and Google Sheets
      • Wild cards and regular expressions in Excel and Google Sheets
      • calculate percentage changes for containing negative numbers and zero
      • convert pounds to grams in Excel and Google Sheets
    • Google Data Studio
      • Charts Guide
        • Scorecard in Google Data Studio
        • Pie Chart in Google Data Studio
        • Bullet Chart in Google Data Studio
        • Gauge Chart in Google Data Studio
        • Line Chart in Google Data Studio
        • Column Charts in Google Data Studio
        • Combo Chart in Google Data Studio
        • Table Chart in Google Data Studio
        • Pivot Table in Google Data Studio
        • Area Chart in Google Data Studio
        • Scatter Chart in Google Data Studio
        • Bubble Chart in Google Data Studio
        • Maps in Google Data Studio
        • Treemaps in Google Data Studio
        • Bullet Chart vs Gauge Chart in Google Data Studio
      • Configuration Guide
        • Background and Border in Google Data Studio
        • Missing Data in Google Data Studio
        • Conditional Formatting in Google Data Studio
        • Chart Header in Google Data Studio
        • Legends in Google Data Studio
        • Reference Lines in Google Data Studio
        • Report Settings
        • Share Report
        • Manual Publishing
        • Version History
        • Embed a report
        • Get a link to your report
        • Schedule Email Delivery
        • Download as a PDF
        • Interface, Menu and Features
        • Most Used Terms
        • Keyboard Shortcuts
        • Theme and Layout
        • 10 Reasons You Should Be Using Google Data Studio
        • FAQs
        • Data Blending in Google Data Studio
      • Menu Explained
        • File Menu
        • Editing Menu
        • View Menu
        • Insert Menu
        • Page Menu
        • Arrange Menu
        • Resource Menu
      • Data Studio Book
      • GA4 Metrics and Dimensions Definition
Google Data Studio > Menu Explained > Page Menu

Page Menu in Google Data Studio

The Page menu lets you add, duplicate, and delete pages. And also navigate and manage the page settings.

Page Menu in Google Data Studio
Page Menu in Google Data Studio

Page Menu

New page (Ctrl+M or ⌘+M)

Insert a new page to your report

Duplicate page

Duplicate your selected page

Delete page

Delete your selected page

Current page settings

This will open a popup window, and you can customize the data source, page background color, and canvas size for the selected page.

Hide current page in view mode

To hide the selected page in the View mode

Manage pages

This will open a popup window, and you can Rename, Duplicate, Delete, Hide in view mode, select an icon, and rearrange the page order.

Next page (Pg-↓)

Navigate to the next page

Previous page (Pg-↑)

Navigate to the previous page

First page (Home)

Navigate to the first page of your report

Last page (End)

Navigate to the last page of your report

Enjoy reading the guide? I have explained every chart available in the new Data Studio Book here. Visual explanations for graphs configurations, style, format, and recommendations. So you can also see how the final result will look and why one design is better than others for the same chart.

Menu Explained:
  • File
  • Editing
  • View
  • Insert
  • Page
  • Arrange
  • Resource
Most Used Features:
  • Report Sharing
  • Manual Publishing
  • Version History
  • Embed a Report
  • Get a link to your report
  • Schedule Email Delivery
  • Download as PDF
  • Interface Menu & Features
  • Most Used Terms
  • Keyboard Shortcuts
  • Theme and Layout

Configuration across chart:
  • Background and Border
  • Missing Data
  • Conditional Formatting
  • Chart Header
  • Legends
  • Reference Lines
  • Report Settings
Excel/Google Sheets FunctionsFormulas and Functions
Google Data StudioCharts GuideConfiguration GuideMenu ExplainedData Studio Book
Google Sites
Report abuse
Google Sites
Report abuse