ICAEW.com works better with JavaScript enabled.

Worksheet design and formatting

View a list of articles and webinars produced by the Excel Community on worksheet design and formatting.

Displaying 1-20 of 248 results
Simon Hurst
Exclusive Including calculations in Microsoft Word
  • Article
  • 27 Mar 2024
  • Simon Hurst
Excel might be the obvious application for all sorts of calculations, but Word also has a calculation feature based on Field Codes that can perform simple calculations, use some functions and also format the result.
Headshot of Bani Lamba
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #10 – Tips and Tricks Live extended
  • Article
  • 25 Mar 2024
  • Bani Lamba
In this year’s first 'Excel Tips and Tricks live – your questions answered' webinar, John Yeldham and Ian Pay tackled Excel questions and queries covering best practice, the use of functions and functionality, and a range of techniques for data handling and analysis in Excel. Bani returns to answer some of the unanswered questions from the webinar.
Simon Hurst
Exclusive Don’t be a check box Charlie
  • Article
  • 26 Jan 2024
  • Simon Hurst
In preparation for a very useful enhancement to the Excel check box feature that is currently available to those on the Insider update channel, we take a look at how check boxes work at the moment before seeing how much easier they will be to use in the near future.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #486 – Revisiting inserting hyperlinks
  • Article
  • 12 Jan 2024
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we take look another look at how to create hyperlinks in your file, to aid quick navigation. We will also cover the differences between hyperlinks in Excel Online and the desktop versions.
Simon Hurst
Exclusive Animated Excel Christmas tree follow-up
  • Article
  • 08 Jan 2024
  • Simon Hurst
Following the response to our 2023 Christmas special, we are extending our interactive Excel Christmas card to demonstrate some additional Conditional Formatting techniques.
Simon Hurst
Exclusive Animated Excel Christmas tree
  • Article
  • 19 Dec 2023
  • Simon Hurst
What better way to spread Christmas cheer than by sending someone an interactive Excel Christmas tree? In this article we use a range of techniques including conditional formatting, Dynamic Arrays and a LAMBDA() function to bring some added sparkle to Christmas.
David Beniam
NEW TECH FEATURES Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Sep-Nov 2023
  • Article
  • 19 Dec 2023
  • David Benaim
David Benaim presents a digest of new features across Microsoft 365 and other business tech products in written, images and video format, covering the last three months.
Liam Bastick
Exclusive Histogram Hiccoughs part 2
  • Article
  • 27 Oct 2023
  • Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Headshot of Ian Pay
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #481 – Refreshing Cell Styles
  • Article
  • 20 Oct 2023
  • Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a General User post in which we're revisiting the topic of cell styles to help support consistency of formatting.
Simon Hurst
Exclusive Advanced conditional formatting – part 3: the horror of peril sensitivity
  • Article
  • 02 Oct 2023
  • Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
Lego graph image
EXCEL COMMUNITY ROUND UP Excel Community round up - September 2023
  • Article
  • 02 Oct 2023
  • Tracy Gray
Here are all the new Excel blogs from the Excel Community in September 2023.
Simon Hurst
Exclusive Advanced conditional formatting – part 2: the highlights
  • Article
  • 25 Sep 2023
  • Simon Hurst
After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting, in this episode, we are looking in depth at the graphical conditional formats.
Simon Hurst
Exclusive Advanced conditional formatting – part 1: automatic currency exchange
  • Article
  • 14 Sep 2023
  • Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. In the first part of a short series, we look beyond the default formats and include a practical example using number formatting.
Ben Ducker
How can “GO TO SPECIAL” help you understand a spreadsheet?
  • Article
  • 07 Sep 2023
  • Ben Ducker
Part 1 of this series covered the basics on how to use the “Go To Special” function. The second part of this three-article series will cover how to use the function to quickly understand a spreadsheet you’re not familiar with.
Lego graph image
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #478 - Introduction to Power Automate
  • Article
  • 05 Sep 2023
  • Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where we will demonstrate how to use Power Automate to run an Office Script against multiple Excel files simultaneously.
Ben Ducker
What’s so special about “GO TO SPECIAL”?
  • Article
  • 22 Aug 2023
  • Ben Ducker
“Go To Special” is a function that can help users get to grips with new spreadsheets a bit quicker and can also be used as part of spreadsheet auditing techniques. The first part of this three-article series will cover the basics of what the “Go To Special” function is and how to use it, what it can do, and some specific applications and use cases.
Liam Bastick
Exclusive Fraudulent Numbers
  • Article
  • 25 Jul 2023
  • Liam Bastick
Sometimes, things aren’t what they seem. Like false advertising, optical illusions and hidden agendas, on occasion numbers in Excel may appear “fraudulent”. And that can cause issues for spreadsheets, whether you are using them for data manipulation / reporting, forecasting, budgeting or modelling.
Ben Ducker
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #5 – Tips and Tricks Live extended: What is your favourite underappreciated formula?
  • Article
  • 13 Jul 2023
  • Ben Ducker
In a recent ‘Excel Tips and Tricks live – your questions answered’ webinar, Ben Ducker and Ian Pay tackled Excel queries covering best practice, the use of functions and functionality and more. Ben returns to answer questions they were unable to respond to during the session.
Lego graph image
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #475 - Using ‘Show Changes’: keeping track of cell edits and the power of cloud storage
  • Article
  • 05 Jul 2023
  • Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we explore using ‘Show Changes’ to keep track of cell edits and learn more about the power of cloud storage.
Jonelle Johnson-Turner
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #473 – Refreshing customising the ribbon
  • Article
  • 30 May 2023
  • Jonelle Johnson Turner
This week, we have a Creator level post in which we're dipping our toes back into the pool of customisation options available through Excel.
Displaying 1-20 of 248 results

Search the Excel Community archive

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Search the archive Access the knowledge base
Excel polaroid