Name: Excel | 準備分享第 1 部分 | Macabacus (Excel | Prepare to Share Part 1 | Macabacus)
Uploaded: 2025-10-27T13:38:38.000Z
Duration: 4 min 2 s

Macabagus has an amazing tool that you can use to clean up the files you've been working on before sharing them with either clients or colleagues.

Macabacus 有一個超讚的工具，可以在你分享檔案給客戶或同事之前，幫你清理一下你正在處理的檔案。

Let's start by heading up to the macabicus section of the ribbon.

首先，我們到 ribbon 的 Macabacus 區塊。

We want to head over to the left hand side where it says Workbook and then click this little share button.

我們要到左邊寫著 Workbook 的地方，然後點一下這個分享按鈕。

One of the things that we want to make note of is these little shield icons that come up for all of those little tools.

其中一個我們要特別注意的地方，是這些小小的盾牌圖示，出現在所有這些小工具旁邊。

We can hover over them to see that this is a tool that's going to help us with potential privacy or security implications.

我們可以將滑鼠移到上面，看看這是一個能幫助我們處理潛在隱私或安全性影響的工具。

For instance, if we've left comments or notes in our file that may be sensitive, macabicus is going to help us remove them.

舉例來說，如果我們在檔案裡留下了可能很敏感的註解或備註，Macabacus 會幫我們移除它們。

Let's focus on the first three tools that are listed.

我們來看看上面列出的前三個工具。

We have the ability to replace formulas with values.

That might be a nice option if we want to send the values through, but

如果我們想傳送值，但不想傳送底層的計算方法論，這會是一個不錯的選項。

not the underlying methodology we've used to calculate those values.

我們也可以重新著色某些字體顏色，並移除註解和備註。

We can also recolor certain font colors and we can remove comments and notes.

關閉這個對話框，然後看看這些功能要怎麼運作。

Let's close out of this dialog box and take a look at how these are going to work.

我們來移到這個工作表中的第二個標籤頁，叫做「項目」。

Let's go ahead and move across to the second tab in this worksheet entitled Items.

可以看到，每個群組都有五個項目，底部會加總這些值，使用一個非常簡單的加總公式。

As we can see, for each group we have five items listed and we have these values that are being added up at the bottom with a very simple sum function.

我們可能不想在檔案中保留公式就傳送出去。

We may not want to send this file through with the formulas in place.

取而代之的是，讓 Macabacus 將這個公式替換成數字 36，這樣會比較好。

Instead, it might be nice to have Macabacus replace this formula simply with the number 36.

We can also see that there are some notes and comments in place here.

我們也可以看到這裡有一些備註和註解。

If we hover over these indicators, we can see that there's a note here and hovering over this one we can see a comment.

如果我們把滑鼠移到這些指示器上，可以看到這裡有一個備註，然後移到這個上面，我們可以看到一個註解。

This may be sensitive information and it might be nice to have macabacus on eliminate those notes and comments for us.

這可能是敏感資訊，最好讓 Macabacus 幫我們移除這些備註和註解。

Macabacus can also recolor certain font colors for us.

Macabacus 也可以為我們重新著色某些字體顏色。

If we go up to macabacus and then click Settings and then here configure, we're going to see this dialog box.

如果我們到 Macabacus，然後點擊設定，接著在這裡點擊設定，我們就會看到這個對話框。

We want to move down the left hand side to where it says Colors and we can see here under Recolor Colors we have five font colors programmed in there.

我們要移到左邊，找到「顏色」，然後在「重新著色顏色」下方可以看到我們在這裡設定了五種字體顏色。

They will all be recolored to our default color, which we can see below down here, which is black.

它們都會被重新著色成我們的預設顏色，我們可以在下方看到，也就是黑色。

So for this particular worksheet we know that these blue font colors are going to get recolored to black once we click that Prepare to Share tool.

所以對於這個特定的工作表，我們知道這些藍色的字體顏色一旦點擊「準備共用」工具，就會被重新著色成黑色。

Let's close out of this dialog box and run the tool.

我們來關閉這個對話框並執行工具。

We need to go up to the Macabreca section of the ribbon on the left hand side where it says Workbook.

我們要到左邊功能區的 Macabacus 部分，找到「工作簿」。

We're going to go into Share and then click Prepare to Share in this dialog box.

我們要進入「共用」，然後在這個對話框中點擊「準備共用」。

It's important to take note of the settings at the bottom.

We can either apply all the changes to a new copy of this workbook or apply the changes to this workbook.

我們可以將所有變更套用到這個工作簿的新複本，或將變更套用到這個工作簿。

Next, what we want to do is investigate these first three options, replace formulas with values, recolor cell fonts, and

接下來，我們要檢查這前三個選項：將公式取代為值、重新著色儲存格字體，以及

As we can see, macabacus went in here and it removed the formula and just replaced this with the 36.

我們可以看到，Macabacus 進入這裡，移除了公式，只將其取代為 36。

We can see that there are no longer any comments or notes in these cells and also we these font colors which were blue have been recolored over to black.

我們可以看到這些儲存格中不再有任何註解或備註，而且這些原本是藍色的字體顏色也已重新著色成黑色。

This is a great tool from macabacus that's going to help us quickly clean up the files that we've been working on and also help us remove information which could be sensitive and confidential before sending the files out externally.

這是 Macabacus 的一個超讚工具，能幫助我們快速清理正在處理的檔案，也能在將檔案分享給外部人員前，移除可能敏感或機密的資訊。

If you're enjoying these tips and would like to see more of our content, please like and subscribe to the channel.

如果你喜歡這些小技巧，想看更多我們的內容，請按讚並訂閱我們的頻道。

Thank you so much for your support and we'll see you soon in the next video.

非常感謝你的支持，我們很快會在下一個影片見到你！