Changing Font, Colour, Alignment, and Background Colours in Spreadsheet Cells
Format your spreadsheet cells by adjusting font styles, colours, alignment, and background shading to improve presentation and readability.
Steps to format spreadsheet cells
Select the target cells
Click on a single cell or click and drag to select a range of cells, rows, or columns you wish to format.Adjust Font and Size
Use the formatting toolbar to open the Font dropdown menu to change the typeface. You can also increase or decrease the Font Size using the adjacent numerical selector.Modify Text Colour and Style
Apply Bold , Italic , or Underline styles to your text. To change the text color, click the Text Colour icon and select a shade from the palette.Set Alignment
Click the Alignment icons in the toolbar to justify your data to the left, center, or right within the cell.Apply Background Colour
Highlight specific data or headers by clicking the Fill Colour icon (bucket icon). Choose a background color to make your rows or columns stand out.
FAQs
What can I change about text inside spreadsheet cells?
In QuoteCloud spreadsheets you can modify the font type, font size and font colour to control how text appears in each cell. These options let you highlight important values, create visual separation between sections, and maintain consistent branding across quotes and proposals generated with our sales quoting software and sales proposal software.
How does alignment work in spreadsheet cells?
Alignment positions text horizontally (left, centre, right) and vertically (top, middle, bottom) inside a cell. Use right alignment for numbers, centre for headers, and left for long descriptive text to make tables, pricing tables and proposal sections easier to read in QuoteCloud and other proposal software outputs.
Can I change the background colour of a cell independently of the text?
Yes. You can apply background colours (shading) to individual cells, entire rows or full columns independently from text formatting. Background shading is ideal for highlighting totals, callouts or whole sections without changing the text itself, helping make quotes and proposal documents clearer for customers.
Why would I adjust font colour and alignment in spreadsheets?
Adjusting font colour and alignment helps emphasise key values, distinguish headers from data, and create a visually organised spreadsheet. For example, totals might be bold, centred and use a different background colour so they stand out in your quote software or proposal software outputs, improving customer comprehension and reducing errors.
Can these formatting options be applied to multiple cells at once?
Yes. Select a range of cells, rows or columns and apply font styles, colours, alignment and background shading in a single action. This makes it fast to update entire pricing tables or proposal sections so your sales quoting software documents remain consistent.
Will formatting in the spreadsheet appear in generated quotes and proposals?
Formatting you apply in QuoteCloud spreadsheets — including fonts, colours, alignment and background shading — carries through to generated quotes and proposals. Preserving styling ensures consistent branding and clearer presentation when you export or send documents from your quote software or proposal software.
How should I format totals and pricing tables for maximum clarity?
Best practice is to right-align numeric values, centre headers, and use bold or larger fonts for totals. Add a contrasting background colour or border to total rows so they pop out. These simple formatting choices improve readability of pricing tables in your sales quoting software and reduce the chance of misunderstandings.
Can I use the spreadsheet styling tools to maintain consistent branding across all documents?
Yes. By setting font types, sizes, colours and background styles in your spreadsheets and templates you can maintain consistent branding across every quote and proposal. Consistent styling in your sales quoting software and proposal software helps present a professional, unified experience to customers.