Essential Notebook Tips and Tricks

To wrap up our section on the Notebook experience, we are going to focus on the "pro" features that will save you hours of manual clicking. Mastering these shortcuts and management tools is what separates a beginner from a professional user.

Essential Keyboard Shortcuts

Keyboard shortcuts are the fastest way to work. Most follow the standard Jupyter convention. To access these, your cell must be in Command Mode (press Esc so the cell border turns blue).

• A: insert a new cell Above the current one;
• B: insert a new cell Below the current one;
• D, D: pressing 'D' twice Deletes the current cell;
• Z: Undo the last cell action (useful if you accidentally deleted code).

Advanced Execution Options

Sometimes, running one cell at a time is too slow. At the top of the notebook, you have the "Run All" button, but there are more precise options available in the cell dropdown or the "Run" menu:

• Run All Above: executes every cell from the top of the notebook down to your current position. Use this to ensure all your variables are initialized;
• Run All Below: executes from your current position to the end of the document;
• Clear State and Results: this clears the output from your screen and wipes the cluster's memory of your variables. This is a "best practice" before sharing a notebook to ensure the code works from a fresh start.

Cell Management and Organization

As your notebooks grow, they can become difficult to navigate. You can use Collapsible Headings to stay organized. If you create a header using Markdown (e.g., # My Header), you can click the small arrow next to it to collapse all the cells underneath it. This allows you to "hide" complex code blocks and only show the relevant results or summaries.

Find and Replace

Just like a text editor, Databricks has a built-in Find and Replace tool. Use Ctrl + F (or Cmd + F on Mac). This is particularly useful when you decide to rename a table or a variable and need to update every cell in the notebook simultaneously.